On Tue, Apr 5, 2011 at 9:27 PM, KPW <[email protected]> wrote: > Truthfully, for my application, there's no reason I couldn't just add > a goofy extra line of code like this: > > <cfset test = DateConvert("local2utc", CreateODBCDateTime("2011-04-05 > 19:59:59"))> > <cfset test = ReplaceNoCase(test, " 24:", " 00:", "ONE")> > > There isn't going to be any other instance of " 24:" anywhere as the > only space in the date/time string is going to be between the date and > the time. > > That's about as easy of a workaround as anything else is going to be I > suspect. LOL.
That works too. I was actually going to suggest that but wanted to do it that Java way first since it seems a bit more elegant, albeit verbose. ;-) Your workaround is straight-forward and a lot less code! Thanks again for letting us know about this. I filed a ticket: http://code.google.com/p/openbluedragon/issues/detail?id=338 You can log in and "star" that ticket to be notified of changes to it. This seems simple enough that I'll try to take a look at it tomorrow, or maybe Andy or Alan will beat me to it. Oh and I forgot to say, welcome to OpenBD! We're here if you need further assistance. Thanks, Matt -- Matthew Woodward [email protected] http://blog.mattwoodward.com identi.ca / Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
