This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 39%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Hello,
What is the difference between day and dayofyear dateparts in SQL Datediff function? both seems to yield the same result? shouldn't dayofyear value in case of diff always be less than 365 ?
Hey,
Yes it is the same effect for DATEDIFF(). For an arithmatetic function like DATEDIFF(), it will have the same result, as the math is still taking into account the same unit: whether it's for day or dayofyear they are both still in days.
Similar thread :
https://dba.stackexchange.com/questions/18065/sql-server-datediff-hows-dayofyear-different-from-day
Hi @R-5499
What is the difference between day and dayofyear dateparts in SQL Datediff function?
For arithmetic functions like DATEDIFF() or DATEADD(), there is no difference between these two datepart values.
shouldn't dayofyear value in case of diff always be less than 365 ?
For this product issue, it is recommended to post it on the feedback site.
Best regards,
Cosmog Hong
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
both seems to yield the same result?
??? Run
select datepart(day, getdate()), datepart(dayofyear, getdate())
Returns 22 and 265; for me it's very different.