Re: SYSDATE in Forms 5.0

From: Mike Rainville <ccre_at_musica.mcgill.ca>
Date: Tue, 04 May 1999 22:40:57 GMT
Message-ID: <372F7719.6F1D7308_at_musica.mcgill.ca>


You can use: SELECT SYSDATE FROM DUAL;
[Quoted] [Quoted] 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.
Received on Wed May 05 1999 - 00:40:57 CEST

Original text of this message