Menu

Knowledge Base

Support  /  Knowledge Base

Snippets

25 Latest Articles Current Articles | Archives | Search

Entries for 'Convert'

12

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&nb...

[Read the rest of this article...]

SQL, Date, Convert
Posted in: SQL Scripts
Actions: E-mail | Permalink | Comments (0) RSS comment feed

120 OLD FREEMANS WAY, BREWSTER, MA 02631
MAILING: P.O. BOX 2342, BREWSTER, MA 02631
PHONE (774) 323-3176