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
