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).
