bulk insert date problem
Posted on 2007-11-15
table includes a smalldatetime field -- call it date1
i'm bulk inserting a ton of data to this table
i just now noticed that all the dates have been altered.
11/13/2007 17:59 in the file is 1900-01-01 17:59:00 in the table
i just truncated the table and re-did one of the file bulk inserts. same thing, every date is current (today) in the file, yet it is 1900 in the table
like i said, it's smalldatetime in the table
the bulkinsert is done via format file, here is that particular attribute in the fmt file:
5 SQLCHAR 0 4 "," 4 date1 SQL_Latin1_General_CP1_CI_AS
is it my format file?
can anybody tell me what's happening to my dates?