When you use date time literals in SAS/ACCESS Interface to ODBC under UNIX, the following errors might occur:

ERROR: CLI open cursor error: [DataDirect][ODBC SQL Server Wire Protocol driver][Microsoft SQL 
Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range 
value.

Here is an example of code that can lead to the problem:

libname x odbc dsn=your_dsn" user=your_user pw=password dbconinit="set DATEFORMAT ydm" 
connection=sharedread ;

   data x;
      set x.test;
      where dt between "28OCT2015:09:00:00"dt and  "30OCT2015:11:59:59"dt;
   run;

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS/ACCESS Interface to Microsoft SQL Server 9.4_M2 is available at:

A fix for this issue for SAS/ACCESS Interface to PC Files 9.4_M2 is available at:

A fix for this issue for SAS/ACCESS Interface to ODBC 9.4_M2 is available at:

A fix for this issue for SAS/ACCESS Interface to DB2 9.4_M2 is available at: