PROBLEM IN DATETIME FORMATTING

Rajesh Goswami

Total Post:29

Points:203
Posted by  Rajesh Goswami
 1578  View(s)
Ratings:
Rate this:
I want to convert datetime (which is value :08/08/2001 ) into 2001/08/08 .But i can not find any appropriate solution in sql server
give the solution of this problem

thanks in advance
  1. Shankar M

    Post:25

    Points:175
    Re: Problem in datetime formatting

    Hi Rajesh,


    Hope this might help you,

    SELECT CONVERT(VARCHAR(10),CONVERT(DATETIME,'21/02/1987',103),111)

    Regards,
    Shankar

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!