Xref: alice comp.databases.oracle.tools:24320
Path: alice!news-feed.fnsi.net!nntp01.net-okbr01.exodus.net!nntp01.net-okbr01.exodus.net!192.26.210.166!sunqbc.risq.qc.ca!carnaval.risq.qc.ca.POSTED!not-for-mail
Message-ID: <372F7719.6F1D7308@musica.mcgill.ca>
From: Mike Rainville <ccre@musica.mcgill.ca>
Reply-To: Michel@cc.mcgill.ca
Organization: McGill University
X-Mailer: Mozilla 4.51 [en] (Win95; U)
X-Accept-Language: en,fr
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.tools
Subject: Re: SYSDATE in Forms 5.0
References: <7gnpis$tlh$1@news6.svr.pol.co.uk>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 26
Date: Tue, 04 May 1999 22:40:57 GMT
X-Complaints-To: abuse@mcgill.ca
X-Trace: carnaval.risq.qc.ca 925857657 132.206.45.62 (Tue, 04 May 1999 18:40:57 EDT)
NNTP-Posting-Date: Tue, 04 May 1999 18:40:57 EDT

You can use: SELECT SYSDATE FROM DUAL;
to get the server time and date. That will slow you
down, depending on how often you do it.

The two different SYSDATEs had my time intervals
coming back negative and time running backwards :)

Yours truly,
Mike Rainville

Graeme King wrote:

> Hi Folks
>
> Has anyone realised that in Forms 5.0, the using the function SYSDATE in
> PL/SQL, returns the date on the *client PC* !!!!
>
> Just thought I'd let you know if you didn't!!
>
> Oracle say they'll fix it in 5.0.8.16.0 whenever that is released.
>
> Happy timestamping!
>
> Graeme King
> Thinking Technology Ltd.