Re: Sysdate doesn't agree with date on Server

Hi,

I don't agree with Marc's opinion, since time differs exactly by 2 hours. This indicates that your oracle server has another time zone than your os.

On Tue, 31 Mar 1998 12:44:48 -0500, Tansel Ozkan <tansel_at_openix.com> wrote:

>Hello all,
>
>When I query the sysdate from Oracle, the time I am getting is different
>than the time on the server machine on which the database is residing.
>What could be the possible reasons for this?
>
>At SQLPlus prompt:
>
>select TO_CHAR(sysdate,'HH-MI-SS') from dual;
>TO_CHAR(SYSDATE,'HH-MI-SS')
>-------------------------------------------
>10-51-13
>
>
>On Unix prompt:
>
>$date
>Tue Mar 31 12:51:13 EST 1998
>
>As you may have noticed, there is exactly a 2 hour of difference.
>
>Any comments..
>
>Thanks..
>
>Tansel

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de