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'}
1 <cfset dateTest_after = createODBCDateTime(dateFormat(now(), 'yyyy-mm-dd')&'00:00:00') />
After spending considerable amount of time today thinking this was a CF bug and testing/re-testing my problem. I was stuck. The code worked fine for the other 27/28 days of the month. In the end I found out it was the lack of a space " " between date and time which caused this problem at the begining of the month. So it should read:
1 <cfset dateTest_after = createODBCDateTime(dateFormat(now(), 'yyyy-mm-dd')&' 00:00:00') />
Painful its been, but a lesson to pass on
TweetBacks
There are no comments for this entry.
[Add Comment] [Subscribe to Comments]