It comes out as "09-07-2002 0:00:00" The time portion is always 0 because CF appears to retrieve the db default date/time format which doesn't have the time portion. So I guess I have to do a SQL function such as the TO_CHAR on it's date/time object and then convert it back to a date/time object once in CF.
Stupid, but...oh well, it works. ----- Original Message ----- From: "Douglas Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 09, 2002 9:39 AM Subject: Re: Retrieving Time in a Query > Cant you do dateFormat(date,"dd-mm-yyyy") timeFormat(date, "hh:mm:ss") What > happens when you do this? > > > > > Douglas Brown > Email: [EMAIL PROTECTED] > ----- Original Message ----- > From: "Bruce Holm" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, July 09, 2002 9:32 AM > Subject: Retrieving Time in a Query > > > > How do you get the "time" portion of a DateTime object stored in an Oracle > > database? > > > > I have a column in a table that is of type "date". I can query this field > > and view the date portion but the time portion is always 0:00 (12:00 AM). > > The time IS reallly stored in the column, but the query CF does only gets > > the date portion. It appears to be getting the default Oracle db value of > > the date portion combined with 0:00 for time. > > > > > > ------------------------------------------------- > > Bruce Holm - Web Programmer > > Lattice Semiconductor Corp. > > [EMAIL PROTECTED] > > ------------------------------------------------- > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
