Re: SYSDATE VS $$DBTIME$$ - UPDATE PROBLEM

Hey, Craig,

You've been bitten by the great oracle 'gotcha'! Try using MI instead of MM in your to_char function. MM is the month. ;=)

Regards,
Steve Cosner

In article <49a5pj$fq1_at_its.hooked.net> Craig <caharper_at_hooked.net> writes: <snip>
> I then tried to set the value
>of the Item to sysdate: ie
>
>:item := to_char(sysdate, 'HH:MM:SS');
>
>But the problem with this is that only the seconds are
>updating. Has anyone encountered this before? How can I get
>the minutes and Hours to update as well?
>
>PLEASE SOMEONE HELP!!!!!!!
>
>Thank you all,
>
>
>Craig Harper =
>
>
>Thinking is more interesting than knowing,
>but less interesting than looking.
>
>
Received on Mon Nov 27 1995 - 00:00:00 CET