How do i change datetime in cyrillic from 4015-01-01 to 2015-01-01 without parsing?

• Thinky Night

  SSCommitted

  Points: 1663

  More actions

  March 13, 2015 at 2:43 am

  #305757

  Hi All,

  I am struggling with SQL Server 2008 database in cyrillic language I try to Load data with ETL.

  But, both of the datetime columns' value are shown as 4015-01-01 as of 2015-01-01.

  How can i load data in Regular datetime format without parsing the column?

  Regards,

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  March 13, 2015 at 2:45 am

  #1783795

  DATEADD(YEAR,-2000,myDateColumn) ?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Thinky Night

  SSCommitted

  Points: 1663

  More actions

  March 13, 2015 at 3:02 am

  #1783803

  Thanks a lot Koen Verbeeck.

  I know. But i am trying to convert without parsing.

  My wonder is there is a notation to convert from cyrillic language to english. Because it is a general problem?