[kronolith] kronolith and oracle..

[Jan Schneider]

Zitat von liamr@umich.edu:

> i gather from the above, to insert a date into mysql...
> 
>     insert into date_test (t_date) 
>         values ('2002-04-05 00:00:00')
> 
> the same sql in oracle looks like...
> 
>     insert into date_test (t_date) values 
>         (to_date('2002-04-05 00:00:00', 'YYYY-MM-DD HH24:MI:SS'));

Unfortunately, at least MySQL doesn't support to_date(). Does anybody has 
an idea how to resolve this issue?
I remember we already had some hard times to find a portable way to insert 
dates between MySQL, PostgreSQL and MSSQL.

Jan.

--
http://www.horde.org - The Horde Project
http://www.ammma.de - discover your knowledge
http://www.tip4all.de - Deine private Tippgemeinschaft