Click here to Skip to main content
12,886,892 members (36,769 online)
Click here to Skip to main content
Articles » Database » Database » General » Revisions

Tagged as


5 bookmarked
Posted 22 Mar 2010

Find all SQL Server DateTime Formats

, 25 Mar 2010 CPOL
When using DateTime with SQL Server, I often forget what the parameters are that allow formatting DateTime in specific ways. When that happens, I fire up this code fragment in SQL Server Management Studio and it neatly lists out every possible parameter with example output.declare @Loop...



Compare Revision Minor Date Status Editor
4 - publicly available No 25-Mar-10 22:28 Available R. Giskard Reventlov
2 No 23-Mar-10 22:24 Composing R. Giskard Reventlov
1 No 22-Mar-10 22:47 Composing R. Giskard Reventlov


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

R. Giskard Reventlov
United States United States
No Biography provided

You may also be interested in...

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170424.1 | Last Updated 26 Mar 2010
Article Copyright 2010 by R. Giskard Reventlov
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid