Re: Database Time Problem
From: Rick <Rick.UK_at_nospambtinternet.com>
Date: Mon, 29 Mar 1999 12:10:45 +0100
Message-ID: <36FF5FB5.4D1F_at_nospambtinternet.com>
Date: Mon, 29 Mar 1999 12:10:45 +0100
Message-ID: <36FF5FB5.4D1F_at_nospambtinternet.com>
Zhardan wrote:
>
> Use 'HH:MI:SS AM'
>
> Ken Halsted wrote in message <922399938.145.86_at_news.remarQ.com>...
> >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.
I made this same mistake ages ago - Zhardan is right. The MM in a format mask refers to months not minutes.
Rick Received on Mon Mar 29 1999 - 13:10:45 CEST