I am trying to convert to MX and am having an issue that is perplexing me. I am pulling a date/time field out of an Oracle 9i database. It is adding tenths of a second to the time. The following date 2003-04-25 09:29:41
appears as 2003-04-25 09:29:41.0 When I try using the date from the query in another query (using the TO_DATE function), it bombs out on me because of the .0 added. Has anyone seen this and know of an overall fix? Thanks, Brian Yager President - North Alabama Cold Fusion Users Group http://www.nacfug.com Ground-Based Midcourse Defense JPO Contractor CSC (256)313-9668 [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
