As it stands right now, if I want to get the hours/minutes/seconds from
an Oracle date column retrieved within a CFQUERY, I need to use to_char
along the lines of "select to_char(thedatecol,'MM-DD-YYYY
HH24:MI:SS')" .. But of course if I ever do a "select *", I'm bungled.
If I do a "select thedate" just like that and then try to work with the
time retrieved, it is always going to be "00:00" unless I explicitly
retrieve the time values as above.
Is there a way to set the default display format of the dates retrieved
from Oracle either on CF's side or on the Oracle server's side?
Anybody know?
TIA,
-R
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
