Re: timestamp format

Mariano schrieb am 11.04.2007 in
<1176324768.421002.203660_at_o5g2000hsb.googlegroups.com>:

> I have a timestamp field in my DB, what is the correct format to
> insert the right parameters???

It depends on the session parameters, the database parameters ... I prefer to do it like

insert into MyTable (MyTimeStamp) values (ToDate('DD.MM.YYYY','11.04.2007'));

But if you need to insert the actual time so you should use sysdate.

insert into MyTable (MyTimeStamp) values (sysdate);

Andreas Mosmann

-- 
wenn email, dann AndreasMosmann <bei> web <punkt> de