# File lib/sequel/adapters/odbc/mssql.rb 45 def default_timestamp_format 46 "{ts '%Y-%m-%d %H:%M:%S.%3N'}" 47 end
Use ODBC format, not Microsoft format, as the ODBC layer does some translation, but allow for millisecond precision.
ODBC
# File lib/sequel/adapters/odbc/mssql.rb 51 def literal_date(v) 52 v.strftime("{d '%Y-%m-%d'}") 53 end
Use ODBC format, not Microsoft format, as the ODBC layer does some translation.