patch: oracle date formats

Hi,

The default Oracle date format set in oracle-sql.lisp doesn't seem to
jive with what actually gets put in the query string for
CLSQL:WALL-TIME types.  It seems newer versions of Oracle are
permissive about this, but it does break on a 9.0.x server.

I've attached a patch that gets things working for me---it's still not
really correct, in that it will break if the WALL-TIME has non-zero
milliseconds, but I can't see that this would have ever worked anyway.

Cheers,
James

_______________________________________________
CLSQL-Devel mailing list
[email protected]
http://lists.b9.com/mailman/listinfo/clsql-devel

diff -ru clsql-3.5.3.orig/db-oracle/oracle-sql.lisp clsql-3.5.3/db-oracle/oracle-sql.lisp
--- clsql-3.5.3.orig/db-oracle/oracle-sql.lisp	2005-11-14 20:06:24.000000000 -0800
+++ clsql-3.5.3/db-oracle/oracle-sql.lisp	2006-02-09 17:00:54.000000000 -0800
@@ -99,7 +99,7 @@
    (date-format
     :initarg :date-format
     :reader date-format
-    :initform "YYYY-MM-DD HH24:MI:SS\"+00\"")
+    :initform "YYYY-MM-DD HH24:MI:SS\".0\"")
    (date-format-length
     :type number
     :documentation