Thursday, August 1, 2013

date convertion to yyyymmdd

To convert the date to yyyymmdd format in sql server

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

Return Value
20130801

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)