Re: Sysdate problem......

The problem is in the format
>
> Hi list,
>
> I've just restored (copy from physical backup) the database and now have
> strange problem in sysdate : sysdate does not take the correct time and the
> minute part does not move forward.
>
> SQL> !date
> Wed Sep 6 09:39:14 CDT 2000
>
> SQL> select to_char(sysdate,'HH:MM:SS') from dual;

                                  ^^

MM is the month as a two digit number, i.e., 09

MI is minutes

                   Pat