Re: SYSDATE in Oracle Forms?
From: Paul Dorsey <pdorsey_at_dulcian.com>
Date: Fri, 28 May 1999 09:36:08 GMT
Message-ID: <cst33.266$eF3.58_at_news.rdc1.nj.home.com>
Date: Fri, 28 May 1999 09:36:08 GMT
Message-ID: <cst33.266$eF3.58_at_news.rdc1.nj.home.com>
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. www.dulcian.com 212 595 7223 Andy Benn wrote in message <3745709f_at_news2.vip.uk.com>...Received on Fri May 28 1999 - 11:36:08 CEST
>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 ?
>
>Andy
>
>eugenef_at_tidalwave.net wrote in message <7habrc$p5e$1_at_nnrp1.deja.com>...
>>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.
>>
>>
><Snip>
>
>