Home > DeveloperSection > Forums > Problem in datetime formatting
Rajesh Goswami

Total Post:29

Points:203
Posted on    August-12-2011 2:24 AM

 MSSQL Server MSSQL Server 
Ratings:


 1 Reply(s)
 1252  View(s)
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


Shankar M

Total Post:25

Points:175
Posted on    February-10-2013 9:34 PM

Hi Rajesh,

Hope this might help you,

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

Regards,
Shankar

Don't want to miss updates? Please click the below button!

Follow MindStick