[freetds] dbdatecrack producing erroneous results

Ken Collins ken at metaskills.net
Sat Apr 21 20:58:16 EDT 2012


> When reading datetime fields of 8 byte precision from SQL server and 
> parsing them using dbdatecrack the date is passed incorrectly for values 
> that are outside of what normally one would use (i.e years in the 
> distant future like 2300 A.D)

Do you mean datetime2? I did not think the datetime type had a user defined precision. If you did mean datetime2, I am not sure FreeTDS supports that. FWIW, I have datetime tested to the hilt in my Ruby C extension of FreeTDS and it works like a champ with dbdatecrack() in all scenarios.

But moot if your talking about datetime2. Again if that is the case, you may want to frame your questions and research around that.


 - Ken



More information about the FreeTDS mailing list