learn

CAST and CONVERT (Transact-SQL)

-20 or 120 2 ODBC canonical yyyy-MM-dd HH:mm:ss (24-hour) -21 or 25 or 121 2 ODBC canonical (with milliseconds) default for time, date, datetime2, and datetimeoffset yyyy-MM-dd HH:mm:ss.fff (24-hour) ...
appuals.com

How to Fix ‘Conversion failed when converting date and time’ in SQL Server

The “Conversion failed when converting date and/or time from character string” error in SQL Server appears when SQL Server cannot interpret a text value as a ...
learn

Configuring Date Time Conversions

The DRDA Service will format string literal date time values from source and into target formats when processing dynamic and static SQL statements, for specific date time and character data types. The ...