Using The TSQL DATEDIFF Function

Here is a quick video training on how to use the T-SQL DATEDIFF function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. And here is the sample code to go with the

Posted in 70-461 Training, TSQL Tagged with: , ,

TSQL Rounding or Truncating DateTime to Nearest Day, Hour, Minute or Second

One thing that I end up having to look search on regularly is rounding of dates and times in Transact SQL, having looked this up too many times I finally realized that it is time for me to do my

Posted in TSQL Tagged with: , ,