var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: BCP/Bulk Insert Datetime Problem,
I am having problems getting BCP/Bulk Insert to insert dates properly.
The dates are being presented to us as,
however, when importing into SQL Server as a datetime field via bcp/bulk insert, they are being inserted as
In Australia, Windows region date setting set correctly and using Latin1_General_CI_AS collation.
Using the following format file (just the relevant sample from the file),
1 SQLCHAR 0 17 "," 1 startDateTime Latin1_General_CI_AS
I tried using
1 SQLDATETIME 0 17 "," 1 startDateTime ""
however this did not work.
Please let me know if any additional info needed.
Dates are stored internally as numbers...the rest is just a presentation issue...look up convert in BOL