[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