Thursday, August 1, 2013

Sql Server - Date convertion to dd-mm-yyyy

To Convert the date to dd-mm-yyyy format, use the following query

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

 Return Value
01-08-2013

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)