Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Why is the date I get via select getdate() wrong in SQL Server?
Neil Pike
March 4, 1999
1 Min Read
A. The usual reason for this is an old bug that caused the date inSQL Server to wrap around after a month or so of continuous running. This wascaused by the variable that the date was being held in overflowing.
The bugs were fixed in one of the 6.5 servicepacks - probably SP2. Apply thelatest servicepack and it should be fixed.
About the Author
You May Also Like
.png?width=700&auto=webp&quality=80&disable=upscale)