how to convert datetime excel sheet to sqlserver datetime

• raaz66

  Mr or Mrs. 500

  Points: 598

  More actions

  December 5, 2009 at 12:24 am

  #143425

  I want o import excel sheet which have a datetime columns such as Date of Birth into sql server datetime,but problem is that in the excel sheet datetime format is "dd-mm-yyyy" and the sql server appends "MM/dd/yyyy".how can i import this column.

• Dugi

  SSCoach

  Points: 17998

  More actions

  December 5, 2009 at 12:39 am

  #1088125

  When you import data from Excel using wizard, the column with Date will appear in this format

  yyyy-mm-dd hh:nn:ss.mss

  so you can now select the imported table with formatting date convert(nvarchar, date_column, 105)

  The script will look like this:

  SELECT your_columns, CONVERT(NVARCHAR, date_column, 105) AS your_format

  FROM imported_table

  ============================================================
  SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
  http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]