String as a date format

  • niladri.primalink

    SSCommitted

    Points: 1751

    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

    Hi,

    Try this from Sql Server

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

  • niladri.primalink

    SSCommitted

    Points: 1751

    Thanks a lot!!!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply