Re: Date & Time Format

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1997/04/03
Message-ID: <5i0vie$632@info.csufresno.edu>#1/1

In article <3343BBD2.12B1_at_adpc.purdue.edu>, Brad Skiles <bwskiles_at_adpc.purdue.edu> wrote:
>Could someone please tell me what I'm doing wrong with the following?
>
>Here's the SQL:
>
>SELECT
> TO_CHAR(SYSDATE,'fmMonth ddth, YYYY, "at" HH:MI P.M.') TODAY
>FROM
> DUAL;
>
>Here's the results:
>
>TODAY
>----------------------------
>April 3rd, 1997, at 9:8 A.M.

Use the following format:

'fmMonth ddth, YYYY, "at" HH:fmMI P.M.'

Note the second 'fm'. It toggles the effect of the first one.

Regards,
Steve Cosner Received on Thu Apr 03 1997 - 00:00:00 CST