The return type of the DATEADD is dynamic based on what you send into it. The solution would be to use datetime2, which provides better accuracy, as you can see in this dbfiddle demo: This is due to a strange limitation 1 in the accuracy of the datetime data type, as documented:Īccuracy | Rounded to increments of.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |