Thursday, August 1, 2013

how to convert date to mm/dd/yyyy format

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

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

Return value
08/01/2013
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)