posted on August 12, 2011 11:26
To format a short date like MM/DD/YY try the following:
select CONVERT(VARCHAR(8), GETDATE(), 1) as MyShortDate
For a complete guide to SQL Server Date Formats visit Sql Server Helper.
There are currently no comments, be the first to post one!