Use DB-Library's dbdatecrack() and PostgreSQL's make_timestamp() to make changes to locales.conf unnecessary

[GeoffMontee]

I don't really like the fact that users have to edit the default locales.conf to allow PostgreSQL to understand timestamp strings returned by FreeTDS.

It looks like it would be easy to use a DB-Library function like dbdatecrack() to pull out the individual parts of timestamp, date and time columns.. Then I could just use make_timestamp() and the other similar functions to build the timestamp, date, or time columns.

I should probably put this code in tdsConvertToCString().

I haven't ever tried to call PostgreSQL's SQL functions (like make_timestamp) from C code, but I think it would be worth it to learn how to do so.

[sumariva]

That would be nice.
I assume that freetds will receive the binary value from server, from 3 to 8 bytes as defined by the column type for date/time types.
Avoid conversion from text string to reduce network traffic if possible.
For larger results, maybe a prepared postgresql statement for date transformation could speed up successive row construction for the result.

[GeoffMontee]

A special conversion has been added for SQL Server and Sybase's DATETIME type using DB-Library's dbdatecrack() and make_timestamp().

f4cab84

[GeoffMontee]

I just realized that the current implementation doesn't properly set the milliseconds value. I'll try to fix that tomorrow.

[GeoffMontee]

I added millisecond support, and fixed some other minor things.

5389eed

[GeoffMontee]

Fixed in v1.0.4.

[gavinwahl]

Can you do this for dates too? I'm getting errors like

invalid input syntax for type date: "Aug 25 2010 12:00:00:AM"