SQL Server Time and Dates Archives

January 16, 2021

How to display full month name from a date in SQL Server?

June 16, 2017

How to display full month name from a date in SQL Server? Which is to say with the complete month names like January, February, March, April, May, etc. written out in full. This query shows you how to get the full month names from the current date or any other date. …

Calculate time difference in hours minutes and seconds in SQL Server

May 30, 2017

How to calculate time difference in hours minutes or seconds in SQL Server? The SQL Server function DATEDIFF() allows us to calculate the difference between two timestamps, but only in one unit. For example, only seconds, or only minutes or only hours. So, calculating the difference between a start date …