Thursday, August 1, 2013

Date convertion to dd/mm/yyyy in sql

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

 Query
SELECT CONVERT(VARCHAR(10), GETDATE(),103)

 Return Value
01/08/2013
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)