Can't you use parseDateTime(date)
Douglas Brown Email: [EMAIL PROTECTED] ----- 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] > > ------------------------------------------------- > > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
