From: Gavin Sinclair <gsinclair@...>
Date: 2002-10-18T09:26:44+09:00
Subject: Re: Date handling with DBI

From: "Gavin Sinclair" <gsinclair@soyabean.com.au>


> From: "Philipp Meier" <meier@meisterbohne.de>
>
>
> > For now, I am resorting to storing my date information as strings in the
> > database.  Does anyone know about the logistics of database-independent
date
> > handling?
>
> I use DBI with Mysql and prepared statements:
>
> stm = dbh.prepare("intert into test values (?)")
> stm.execute(Time.now)
>
> -billy.

I tried that code and got the following error:

.../site_ruby/1.6/DBD/Oracle/Oracle.rb:290:in `execute': ORA-01861: literal
does not match format string (DBI::DatabaseError)

I guess the driver's just not built for it :(

Gavin