I forgot to mention that I want to retain the date and time portions as a datetime object in CF. Yes I am aware that I can convert the Oracle date/time object into a character string with TO_CHAR function but that loses the date/time object status in CF. I want it as a date/time object so I can format it using multiple masks in CF using TimeFormat function.
------------------------------------------------- Bruce Holm - Web Programmer Lattice Semiconductor Corp. [EMAIL PROTECTED] ------------------------------------------------- ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
