why not do a regex replace on any .0's in the string prior to using it...then it wont matter...
tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -----Original Message----- From: cftalk [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 4:16 PM To: CF-Talk Subject: date/time values having a .0 added to the seconds... 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 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
