DATETIME Functions

Having lived in the electronic trading industry for so long, I have become intimately familiar with our friend, DATETIME.  And DATE, TIME, DATETIME2, CURRENT_TIMESTAMP, DATEADD, DATEPART, DATEDIFF, DATENAME... I could go on and on.  


In my opinion, DATETIME2 was a wonderful thing.  Finally the precision of my date values are maintained!  There are many other DATE-specific changes in the new engine, too.  DATE and TIME, for example.  How many times are you stripping off one or the other?!  These changes are long overdue, and they really ease the date-related possibilities within SQL Server.


At this point, I'm just going to post tons of fun date stuff.  Different DATETIME functions, varying conversion methods, DO's and DONT's, even unexpected errors that you may receive, and why.  Let me know if you have any questions, and please feel free to send your own.  I would love to see them!

• New Date datatypes
• Different DATETIME formats
• Three-character Month Name, date and year
• Calculate a different date

...in process