datediff

About this tag
The datediff tag on WindowsForum.com covers issues related to the SQL Server DATEDIFF function, particularly overflow errors that occur when date differences exceed the function's range. A common scenario involves Windows HPC (High Performance Computing) services failing after updates on Server 2019, where the datediff function in SQL queries returns an overflow error due to large datepart differences. Discussions focus on troubleshooting this error by using less precise dateparts or adjusting query logic. The tag is relevant for system administrators and IT professionals dealing with SQL Server errors in Windows Server environments.
  1. H

    Windows HPC fails to start after update (Server 2019)

    Hi all, When looking at the logs after the HPC console add-in fails to start I get the following (HPC scheduler): Exception: System.Data.SqlClient.SqlException (0x80131904): The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large...
    • hob63
    • Thread
    • availability connection datediff error exception hpc logs monitoring server 2019 sqlclient stack trace task scheduler update windows
    • Replies: 1
    • Forum: Windows Server Forums