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
