That is a solution I have thought of...Problem is, this is a very large application. Going through everypage to see if changes need to be made would be a huge effort. So far, that is my solution. I sure hope that won't be the only way to do it.
Thanks, Brian ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, June 25, 2003 3:16 PM Subject: RE: date/time values having a .0 added to the seconds... > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
