Thursday, August 1, 2013

how to convert date to dd-mm-yyyy format

To convert a given date to dd-mm-yyyy format in sql server,
use the following query

Query
SELECT CONVERT(VARCHAR(30), GETDATE(),110)

Return value
08-01-2013

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)