Thursday, August 1, 2013

convert date to yyyy/mm/dd in sql server

To convert the date to yyyy/mm/dd in sql server

Query
SELECT CONVERT(VARCHAR(20), GETDATE(),111)

Result
2013/08/01

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)