What version are you running? On Apr 5, 2011 7:36 PM, "K P W Consulting, Inc." <[email protected]> wrote: > Hi All, > > I'm new to the group and am hoping someone here can provide a quick answer. > > I recently converted over a script to OpenBD and everything appeared to work > fine... until a couple hours ago. > > The culprit appears to be the DateConvert() function along with local2utc. > > I am able to reproduce the problem this way: > > <cfoutput> > #DateConvert("local2utc", CreateODBCDateTime("2011-04-05 19:59:59"))# > </cfoutput> > > The result I get back is: > > {ts '2011-04-06 24:59:59'} > > This throws a database error of "The conversion of a char data type to a > datetime data type resulted in an out-of-range datetime value." > > What I was EXPECTING to see was: > > {ts '2011-04-06 00:59:59'} > > Can someone point me in the right direction as to how to get the time to > behave as I would like it... that is... 00:00:00 to 23:59:59 > > I don't want the "24:00:00 to 24:59:59" range. > > Thanks in advance. > > -- > official tag/function reference: http://openbd.org/manual/ > mailing list - http://groups.google.com/group/openbd?hl=en
-- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
