[kronolith] kronolith and oracle..

[Brandon Knitter]

I know Sybase "just figures it out" so I'm sure that MS-SQL wouldbe the same.

Let me dig out the SQL92 spec, there must be a standard way to insert dats, I
would say that perhaps by epoch/milli (number of milliseconds past the epoch).

You'd figure there just /has/ to be a way, no? :)

-- 
-bk


Quoting Jan Schneider <jan@horde.org>:

> 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
> 
> -- 
> Kronolith mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe@lists.horde.org
> 
>