Re: Database Time Problem

Hello Ken,

it should be:

select to_char(sysdate, 'HH:MI:SS AM') from dual;

Rainer

Ken Halsted wrote:
>
> I'm wondering why when I issue the following command that I keep getting the
> same MINUTE portion of time.
>
> select to_char(sysdate,'HH:MM:SS AM')
> from dual
>
> Every time I issue this command, the Seconds change but the Minutes are
> staying the same. I don't know about the Hour yet but, does anyone know
> what's going on?
>
> Ken.
Received on Fri Mar 26 1999 - 13:43:09 CET