UnsuccessfulReturnCode "odbc_SQLExecDirectW" (-1) "[Microsoft][ODBC Driver 13 for SQ L Server][SQL Server]Conversion failed when converting character string to smalldatetime data type.[Microsoft][OD ...

Sometimes, string-to-date conversion in SQL Server results in an error, not because of the date or time formats used, but because you’re attempting to store incorrect information that’s not acceptable ...

originally we used sql server storage, but we moved to redis and the issues go on. interestingly the format of the CreatedAt field in the jobs is sometimes 1679880723201 and sometimes 2023-03-27T07:30 ...

SQL Server has many different ways (column types) to represent date/time values, and depending on which one is used in the database table, you may have some surprising results when trying to consume ...