Data Mismatch in DateTime Field

• sqlstud

  SSCrazy

  Points: 2527

  More actions

  September 26, 2012 at 5:55 am

  #264716

  Hi,

  While loading the data from Excel file to staging table using SSIS 2005 contains one column "StartDate" which is DateTime datatype.

  Please find the values below

  Custname No StartDate

  xyz 24720100107103549

  dfg 5020100107113727

  dfg 5018/08/2011

  dfg 5018/08/2011

  Some of the values in "StartDate" exists in the format as 20100107103549.

  Some of the rows contains '18/08/2011'

  Need all the data in the column should be in format DD/MM/YYYY

  ie 03/03/2009

  Could you please give me the suggestion

  Regards

  SqlStud

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  September 26, 2012 at 6:04 am

  #1542333

  Please do not cross post, replies here please http://www.sqlservercentral.com/Forums/Topic1364523-148-1.aspx