SQL Server Can't Handle Milliseconds
- October 19, 2010 10:36 AM
- Microsoft Tools
- Comments (3)
I've started up a new job, and one of the tasks I'm going to have to tackle is creating a system where nearly every record has an effective date: only the information with the most current date that has happened so far is considered in use. This means that I've got to do some crazy date manipulation to keep things running smoothly. While working on some stored procedures, I found an issue with SQL Server and its handling of datetime values when incrementing in milliseconds.