Thursday, August 1, 2013

convert date to yyyy.dd.mm format in sql

To convert the given date to a format like yyyy.dd.mm

Query
SELECT CONVERT(VARCHAR(11), GETDATE(),102)

Return Value
2013.08.01
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)