Re: SYSDATE in Oracle Forms?

Sysdate (like "user") is a database "virtual" column so if you include it in a select statement, you will get the system date off the database server, not the application server.

select trunc(sysdate) into my_date_field from dual;

cheers, sue

Simon Hedges <shedges_at_hhhh.freeserve.co.uk> wrote in article <7had02$9r3$1_at_news4.svr.pol.co.uk>...

> You could try creating a database function (e.g. fn_dbdate)
> that returns a date parameter.

> This would be executing the 'sysdate' command actually on the database
> and returning the result to the form, so no actual forms processing
> would be used the calculate the data. In theory, this should work.
>

> eugenef_at_tidalwave.net wrote in message <7habrc$p5e$1_at_nnrp1.deja.com>...
> >
> >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 Wed May 12 1999 - 03:16:34 CEST