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'}
Comments
Im setting the time to midnight as well though.
I know... doesn't createOdbcDate() default to 12:00 midnight? Or is that up to the DBMS?
I always just thought that was down to the DBMS and really didnt want to leave that to chance? Either way I suppose its better to be save than sorry :o)
cf datetimes are decimal days since it's epoch. this should strip the time: createODBCDATETIME(int(now())).
