AKAWN® LIMITED

SQL Server specialists

datediff and datepart abbreviations

When working with dates/times it can sometimes get a bit confusing when abbreviation options are introduced e.g. abbreviations may pad 0’s,use 24hr (HH) vs 12hr (hh) etc.
 
This post is simply a confirmation that abbreviations in datediff and datepart do return the same value.

image

Category: General

Your email address will not be published.

Just checking you are not a computer: * Time limit is exhausted. Please reload the CAPTCHA.