Formatting a Short Date in SQL using Convert Function

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.

Posted in: SQL Scripts

Actions: E-mail | Permalink | Comments (0)

Post Rating

12345

There are currently no comments, be the first to post one!

Only registered users may post comments.

120 OLD FREEMANS WAY, BREWSTER, MA 02631
P. O. BOX 2342, BREWSTER, MA 02631
(774) 323-3176
CONTACT US