Re: oracle date

From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 4 Apr 2003 08:49:28 -0800
Message-ID: <1b061893.0304040849.28928e91@posting.google.com>

If you're on 9i, read about the new datatypes "timestamp with time zone" and "timestamp with local time zone", that might be what you need. Note that the default display format of such fields is decided with the parameter nls_timestamp_format, which can be altered at the session level.

Daniel

"Peter Valicek" <Sonny2_at_gmx.net> wrote in message news:<pan.2003.04.03.20.45.04.397613_at_gmx.net>...
> Hello NG,
>
> I use an oracle DB, to getting infotmations. But the timestamps from value
> date has only the format 13-MAR-2003 for example.
> I know to get the formated date like to_char(.....) but, as well they
> stored by GMT +0.
> So how can I get the correct time by my GMT, which is GMT+1 ( MET ).
>
> Thx, in forward.
>
> -Peter
Received on Fri Apr 04 2003 - 10:49:28 CST