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… Read More »TSQL Rounding or Truncating Date Time to Nearest Day, Hour, Minute or Second
Here is a quick video training on how to use the T-SQL DATEPART function on SQL Server. This was originally part of my free SQL query training… Read More »Using The TSQL DATEPART Function
You can use the TSQL DATEPART function to extract individual parts of the date from a date or time item. For instance: Will return the… Read More »The TSQL DATEPART Function
Here is a quick rundown on the T-SQL DATEPART function for SQL Server. DATEPART is used to pull a single part of a date/time element… Read More »T-SQL DATEPART Explained
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… Read More »TSQL Rounding or Truncating DateTime to Nearest Day, Hour, Minute or Second