SQL Server and Custom Date Formats
Today SQL Server Central is featuring my article Dealing with custom date formats in T-SQL.
There’s a lot of code on that page and I thought that making it available for download would make it easier to play with.
You can download the code from this page or from the Code Repository.
- CustomDateFormat.cs
- formatDate_Islands_iTVF.sql
- formatDate_Recursive_iTVF.sql
- formatDate_scalarUDF.sql
- parseDate_Islands_iTVF.sql
I was also asked to include a performance chart for the different methods included in the article. Here’s a quick’n’dirty Excel bar chart (I didn’t include the recursive iTVF for the sake of readability).
I hope you enjoy reading the article as much as I enjoyed writing it.
Posted on March 23, 2012, in SQL Server, SQL Server Central, T-SQL and tagged SQL, SQL Server, T-SQL. Bookmark the permalink. 1 Comment.
spaghettidba 
Pingback: Formatting dates in T-SQL « spaghettidba