Click here to Skip to main content
Click here to Skip to main content
Search within:



Articles » Database » Database » General » Revisions
 
Comments & Discussions

Find all SQL Server DateTime Formats

By , 25 Mar 2010
 

Revisions


  

Compare Revision Minor Date Status Editor
publicly available No 26 Mar '10 - 4:28 Available mark merrens
2 No 24 Mar '10 - 4:24 Composing mark merrens
1 No 23 Mar '10 - 4:47 Composing mark merrens

License

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

About the Author

 mark merrens
United States United States
Member

I am me: what else is there?

About Article
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...
Type Tip/Trick
Licence CPOL
First Posted 22 Mar 2010
Views 4,118
Bookmarked 5 times
Top News

Math Primers for Programmers

Get the Insider News free each morning.
Related Videos
Learn .NET and C# in 60 Days Lab14(Day 6): - Getting Data from SQL Server
Video #3 - Virtual Machines in Hyper - V
SQL Server Functions that helps to convert date and time values to and from string literals and other date and time formats.
Date and Time as Separated Types
Formatting Local Datetime to UTC in SQL Server
Date and Time Data Types and Functions - SQL Server (2000, 2005, 2008, 2008 R2, 2012)
Most Commonly Used Functions in SQL Server 2005/2008
Robyn Page's SQL Server Date/Time Workbench
SQL 2005 Time Zone Conversion Functions
Finding the nth day of the nth week
Google like Calendar in ASP.NET (AJAX)
Time Period Library for .NET
Creating a Date Process Library and WCF Service for Date and Age Processing
Convert SQL Server DB to SQLite DB
Accurate DATETIME Range Searching in SQL Server
Remove Duplicate Rows from a Table in SQL Server
How to Use SQL Server to Select Records for a Scheduled Date
Encrypted columns and SQL Server performance
Building an embedded database engine in C#
Inserting XML formatted data into SQL Server 2000
Silverlight 4 with (HTTP) Duplex and SQL Notifications
Schema Generator
Permalink | Advertise | Privacy | Mobile
Web03 | 2.6.130516.1 | Last Updated 26 Mar 2010
Article Copyright 2010 by mark merrens
Everything else Copyright © CodeProject, 1999-2013
Terms of Use
Layout: fixed | fluid