[freetds] dbdatecrack producing erroneous results
freddy77 at gmail.com
Sun Apr 22 03:25:47 EDT 2012
Il 22 aprile 2012 01:58, Ken Collins <ken at metaskills.net> ha scritto:
>> 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
No, ms dblib does not support protocols which allow datetime2 on wire.
More information about the FreeTDS