[kronolith] Re: kronolith and oracle..

Liam Hoekenga liamr@umich.edu
Tue, 11 Jun 2002 13:20:47 -0400


just an fyi -

if you change Oracle's default date format (for your database) to 
'YYYY-MM-DD HH24:MI:SS', mysqlesque date inserts seem to work.  I've not tried
this with kronolith, but it makes me hopeful.

liam
--------------------------------------------------------------------

SQL> create table test ( 
  2  test date);
Table created.

SQL> describe test;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TEST                                               DATE

SQL> insert into test (test) values ('2002-04-05 00:00:00');

1 row created.

SQL> select * from test;

TEST
-------------------
2002-04-05 00:00:00