Re: oracle date

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 4 Apr 2003 02:18:34 -0800
Message-ID: <a20d28ee.0304040218.61cf0055@posting.google.com>

"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

By making sure the O/S of your server has the correct timezone set. Apparently it hasn't. The sysdate pseudo function just reads the system clock.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Fri Apr 04 2003 - 04:18:34 CST