Post reply

String as a date format

  • 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!!

  • September 12, 2013 at 1:19 am

    #1649591

    Hi,

    Try this from Sql Server

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

  • September 12, 2013 at 1:33 am

    #1649597

    Thanks a lot!!!

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

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