Bug with new release candidate, 'freebcp in', and date format

Ed Avis <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
I've found a change in behaviour with date parsing and freebcp.
Create a global temporary table to copy into:

    > create table ##test (dt date not null, value int not null)

Now make a CSV file and load it in:

    % echo 26-Jul-2000,1 >test.csv
    % freebcp '##test' in test.csv -S MYSERVER -U mydb -P mypass -c -t ','

The date in the CSV file is misparsed:

    > select * from ##test;
     dt         value
     ---------- -----------
     1900-07-01           1

This is new with 0.95 - it works OK with revision 0a42888.  I didn't see it
mentioned in the ChangeLog file.

Are these dates being parsed by the server or by freebcp itself?

-- 
Ed Avis <[email protected]>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.