It tried to convert following time in Power Shell Script '2022-01-02T11:43:23.100Z' using Convert Function, and Cast. The tried same in SSMS and passed. Both SSMS and Power shell were connect to same instance of SQL Server 14.0.1000.
Error message indicates in Power shell it is failing in...
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...