On MSSQL < 2008 there is no timestamp (the default type for 'date), we use datetime...

diff --git a/sql/generic-odbc.lisp b/sql/generic-odbc.lisp
index 766606035a3c2cc2f64e6e5d3f194becce3ff28e..e4c37529f2e07a32778f46fe01b3ffa0d1c0e331 100644 (file)
--- a/sql/generic-odbc.lisp
+++ b/sql/generic-odbc.lisp
@@ -76,6 +76,10 @@
                                         (db-type (eql :mssql)))
   (declare (ignore args database))
   "DATETIME")
+(defmethod database-get-type-specifier ((type (eql 'date)) args database
+                                        (db-type (eql :mssql)))
+  (declare (ignore args database))
+  "DATETIME")
 
 (defmethod database-get-type-specifier ((type (eql 'boolean)) args database
                                         (db-type (eql :mssql)))