// Will not get stuck in date formatting again
You’ve all been there, you’ve all banged your head against the monitor just because you could not remember that code for the specific date formatting you needed in SQL. I know I have.
I SQL 2012 this is no longer such a headache to remember all those codes – JAY!
Ex. from SQL 2008 R2 and older:
SELECT CONVERT(VARCHAR(10), GETDATE(), 105) AS [DD-MM-YYYY] --Italian SELECT CONVERT(VARCHAR(10), GETDATE(), 104) AS [DD.
[...]