From: Brian Candler <B.Candler@...>
Date: 2003-05-02T18:49:36+09:00
Subject: Re: Some OCI8 comments

> - changes the default to_s format from
>          YYYY/MM/DD HH:MM:SS
>   to     YYYY-MM-DD HH:MM:SS
> 
>   The latter is, I believe, a more accurate ISO date format. It also happens
>   to be the same as mysql provides.

Actually, I have come across a problem here, trying to insert dates which
were exported as CSV from another database; e.g. inserting string
"2003-05-02 10:45:00" into an Oracle DATE column, I get:

/usr/local/lib/ruby/site_ruby/1.6/DBD/OCI8/OCI8.rb:37:in `raise_error': ORA-01861: literal does not match format string (DBI::DatabaseError)

Does anyone know what 'format string' Oracle is expecting? If I try
"2003/05/02 10:45:00" it doesn't work either.

Of course I can insert
    TO_DATE(?,'YYYY-MM-DD HH24:MI:SS')

but I have a generic table-loader which just takes a CSV file and just uses
INSERT on each row... it would be nice for string-format dates to be mapped
into DATE columns automatically.

Cheers,

Brian.

P.S. I see that the OCI8 DBD in ruby-oci8-0.1.3 supports mapping of Oracle
error codes to the appropriate DBI exceptions - excellent!