Date & Time Format

From: Brad Skiles <bwskiles_at_adpc.purdue.edu>
Date: 1997/04/03
Message-ID: <3343BBD2.12B1@adpc.purdue.edu>#1/1

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.

Notice the "9:8"? It should be "9:08". This only occurs when the the first digit of the minutes is a zero (0). For example, if I run the query 5 minutes later, it will correctly report the time as "9:13". I'm rather befuddled, because I really think I'm doing it right.

TIA.
--brad Skiles, dba

Purdue University
bwskiles_at_adpc.purdue.edu Received on Thu Apr 03 1997 - 00:00:00 CST