Snippets

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)

12345

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

Name (required) Name Is Required

Email (required) Email Is Required Invalid Email Address

Website

Comment Is Required

Notify me of followup comments via e-mail