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 own blog post for it. First off, whats the difference between rounding and truncating in these examples. Rounding rounds to …
TSQL Rounding or Truncating Date Time to Nearest Day, Hour, Minute or Second Read more »
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 DATEDIFF video tutorial: See Also Additional Training on my YouTube Channel Free SQL Query Training 70-461 exam preparation
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 own blog post for it. First off, whats the difference between rounding and truncating in these examples. Rounding rounds to …
TSQL Rounding or Truncating DateTime to Nearest Day, Hour, Minute or Second Read more »