From: Nathan Bird <nathan@acceleration.net>
Date: Wed, 10 Feb 2010 22:08:02 +0000 (-0500)
Subject: On MSSQL < 2008 there is no timestamp (the default type for 'date), we use datetime... 
X-Git-Tag: v5.0.3~3^2~1
X-Git-Url: http://git.kpe.io/?p=clsql.git;a=commitdiff_plain;h=85ec9eefa107bb000198c381ffba15c8f4bb086b

On MSSQL < 2008 there is no timestamp (the default type for 'date), we use datetime which is present on all versions of sqlserver.
---

diff --git a/sql/generic-odbc.lisp b/sql/generic-odbc.lisp
index 7666060..e4c3752 100644
--- 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)))