Datediff overflow error - by Nuwan Asiri

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 795662 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 8/1/2013 3:33:12 AM
Access Restriction Public


select datediff(second,getdate()-(100*365),getdate())
datediff cannot handle 100 years when use second as interval
Sign in to post a comment.
Posted by Microsoft on 10/23/2013 at 5:43 PM
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SQL Server. Thanks again for reporting the product issue and continued support in improving our product.