CreateODBCDatetime tale of caution
I have a scedule task which runs daily and we've noticed that at the begining of the month it has been behaving oddly. Its been changing dates around. i.e its been converting 2006-08-03 to 2006-08-30. Below is an example of whats happend:
Before: {ts '2006-08-01 13:01:00'}
After: {ts '2006-08-10 00:00:00'}
<cfset dateTest_after = createODBCDateTime(dateFormat(now(), 'yyyy-mm-dd')&'00:00:00') />
<cfset dateTest_after = createODBCDateTime(dateFormat(now(), 'yyyy-mm-dd')&' 00:00:00') />
Painful its been, but a lesson to pass on
Feed
Twitter
Recent tunes
*** There are no comments for this entry. ***
[*** Add Comment ***]