Re: patch: oracle date formats

Kevin Rosenberg <kevin-HJRc7zDS/[email protected]> Tue, 28 Feb 2006 08:52:48 -0700
Newsgroups gmane.lisp.clsql.devel
Message-ID <[email protected]>
James Bielman wrote:
> 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.

Thanks for the patch. I've commited it without testing since I don't
have Oracle currently available.

> 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.

Yes, accepting the non-zero milliseconds patch for postgresql has overall
caused more problems than it fixed.

Kevin