Re: timestamp format

On Wed, 11 Apr 2007 23:09:07 +0200, Andreas Mosmann <mosmann_at_expires-30-04-2007.news-group.org> wrote:

>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

Sorry to say so but timestamps are NOT dates! If the OP has a true timestamp column (of datatype timestamp) he needs the SYSTIMESTAMP function.
dates never contain any timezone info!!!

-- 
Sybrand Bakker
Senior Oracle DBA