Tag: DATEDIFF

DATEDIFF() – Sub-second Functions

admin

I am a devoted in my creation of short articles or tidbits on Transaction SQL date/time functions. Most, if not all, modern day computer systems collect data which contains dates and times. Many times you will want to calculate the difference between two given dates using a particular unit of measure (date part) like milliseconds, microseconds, and nanoseconds. Today, I will be exploring the DATEDIFF() function. This function has 12 different input parameters that can be passed to change the resulting output. To summarize, the function takes a date part,…

DATEDIFF() – Time Related Functions

admin

I am constant in my creation of short articles or tidbits on Transaction SQL date/time functions. Most, if not all, modern day computer systems collect data which contains dates and times. Many times you will want to calculate the difference between two given dates using a particular unit of measure (date part) like hours, minutes, or seconds. Today, I will be exploring the DATEDIFF() function. This function has 12 different input parameters that can be passed to change the resulting output. To summarize, the function takes a date part, a…

DATEDIFF() – Date Related Functions

admin

I am unfluctuating in my creation of short articles or tidbits on Transaction SQL date/time functions. Most, if not all, modern day computer systems collect data which contains dates and times. Many times you will want to calculate the difference between two given dates using a particular unit of measure (date part) like day, week, month, quarter or year. Today, I will be exploring the DATEDIFF() function. This function has 12 different input parameters, units of measure (date part), that can be passed to change the resulting output. To summarize,…