Re: SYSDATE in Forms 5.0

From: <mcotter_at_my-dejanews.com>
Date: Thu, 06 May 1999 12:05:06 GMT
Message-ID: <7gs0hh$m1s$1_at_nnrp1.deja.com>


I use sysdate all the time very successfully...someone else suggested to me to set the datatype of the DATE field you are selecting into to a 'DATETIME' stamp...and this works just fine....otherwise, write a trigger on your table to format the date to include the time.....

In article <372F7719.6F1D7308_at_musica.mcgill.ca>,   Michel_at_cc.mcgill.ca wrote:

> 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.
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu May 06 1999 - 14:05:06 CEST

Original text of this message