Date Format in bulk insert

• vsjayashri

  Right there with Babe

  Points: 797

  More actions

  January 26, 2010 at 1:19 am

  #214883

  Hi

  I have a csv with

  a,b,13/11/2009

  b,c,15/11/2009

  When I used the smalldatetime for the date column, I could not import the data in the table.

  Can anyone help how to import date field in BULK INSERT.

  jayasri

• ohack

  SSCrazy

  Points: 2043

  More actions

  January 26, 2010 at 7:35 am

  #1108669

  Hi,

  Need to know the error message you're getting. Could be you just need to set the dateformat:

  SET DATEFORMAT dmy;