Problem Note 41854: Unable to use string timestamp literals with the SQL Native Client 10.0 driver
The following error can occur when you set a timestamp using literal values in SAS/ACCESS® Interface to ODBC and you are using Microsoft SQL Server Native client:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when
converting date and/or time from character string.
With the Microsoft SQL Server Native Driver, the datetime literal value is cast to a DATETIME2 with the following format:
This level of precision might be more than what is passed in the literal timestamp string. If this amount of precision is required, you can specify the DATETIME2 scale either in a LIBNAME statement or in a DATA statement, as shown in the following examples: