Re: SYSDATE in Oracle Forms?

From: Paul Dorsey <>
Date: Fri, 28 May 1999 09:36:08 GMT
Message-ID: <cst33.266$>

It depends on the version of Forms you are running. Some return the PC date, some return sysdate. If you want to make sure you get the sysdate use
select sysdate from dual

Paul Dorsey
Dulcian, Inc.
212 595 7223
Andy Benn wrote in message <>...

>I changed my PC to be 24-Dec-1999 and sysdate still returned 21-May-1999.
>Surely Sysdate will return the server date as it comes from SYS.DUAL in the
>first place. What platform you working on ?
> wrote in message <7habrc$p5e$>...
>>Hello Gurus,
>>Originally we thought SYSDATE in Oracle Forms meant the database
>>server's date.
>>At least it seemed that way in Forms 4.5. In Forms 5.0, SYSDATE
>>definitely gives
>>us the PC's operating system date while we wanted the database one.
Received on Fri May 28 1999 - 11:36:08 CEST

Original text of this message