[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