Knowledge Base

Snippets

12

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

Post Rating

Comments

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

Post Comment

Only registered users may post comments.