String as a date format

• niladri.primalink

  SSCommitted

  Points: 1751

  September 12, 2013 at 1:05 am

  #297732

  Hi All,

  From other source I am getting a data as string format like 'Sep 6 2013'. I want to see it as a Date format.

  and the date format should be DD/MM/YYYY.

  It means 'Sep 6 2013' looks like 06/09/2013.

  Is it possible to to that in SQL server?

  Please help!!

• Bhaskar.Shetty

  Hall of Fame

  Points: 3054

  September 12, 2013 at 1:19 am

  #1649591

  Hi,

  Try this from Sql Server

  select convert(varchar(10),convert(datetime, 'Sep 6 2013'),103)

• niladri.primalink

  SSCommitted

  Points: 1751

  September 12, 2013 at 1:33 am

  #1649597

  Thanks a lot!!!