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] ------------------------------------------------- ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
