Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Sysdate problem......

Re: Sysdate problem......

From: Pat Hildebrand <pat_at_ssc.upenn.edu>
Date: Wed, 6 Sep 2000 15:25:57 -0400 (EDT)
Message-Id: <10611.116335@fatcity.com>


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
Received on Wed Sep 06 2000 - 14:25:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US