allow setting the odbc::*time-conversion-function* to work by
authorRuss Tyndall <russ@acceleration.net>
Tue, 19 Jan 2010 15:22:53 +0000 (10:22 -0500)
committerRuss Tyndall <russ@acceleration.net>
Tue, 19 Jan 2010 15:22:57 +0000 (10:22 -0500)
specifying the output type of timestamps to :time instead of T (which
caused an after the fact conversion to string)

db-odbc/odbc-dbi.lisp

index 0b88ee20695267bc10612a2928595d29d7fdb57b..4611cfe232aad6b728d12626b6eac3ea1d6d4f4d 100644 (file)
@@ -465,10 +465,11 @@ This makes the functions db-execute-command and db-query thread safe."
                 (#.odbc::$SQL_C_SSHORT :short)
                 (#.odbc::$SQL_C_STINYINT :short)
                 (#.odbc::$SQL_C_SBIGINT #.odbc::$ODBC-BIG-TYPE)
+                (#.odbc::$SQL_C_TYPE_TIMESTAMP :time)
                 (#.odbc::$SQL_C_CHAR
-                   (or (case (aref column-sql-types i)
-                         (#.odbc::$SQL_NUMERIC :double))
-                       T))
+                   (case (aref column-sql-types i)
+                     (#.odbc::$SQL_NUMERIC :double)
+                     (t t)))
                 (t t)))
              (t t)))))
   query)