Monday, August 1, 2011

Change date format mm/dd/yy to dd/mm/yy using query?

Select CAST(DAY(GETDATE()) AS VARCHAR(2)) + ‘/’ + CAST(MONTH(GETDATE()) AS VARCHAR(2)) + ‘/ ‘ + CAST(YEAR(GETDATE()) AS VARCHAR(4)) AS DATE

No comments:

Post a Comment