to_char Bug...

From: "Arthur M(dot) Kang" <arthur(at)levelogic(dot)com>
To: bugs(at)postgresql(dot)org
Subject: to_char Bug...
Date: 2000-08-21 21:41:09
Message-ID: 39A1A1F4.70A82D15@levelogic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The to_char functions seems to be barfing on the AM/PM stamp on hours 12
and 13. I'm not sure if this is already known, but I thought I would
just submit it...

Arthur

swingwire=# select
to_char(timestamp(date('now'),'12:57:11'::time),'FMMonth DD, YYYY at
HH:MI pm');
to_char
-----------------------------
August 21, 2000 at 12:57 am
(1 row)

swingwire=# select
to_char(timestamp(date('now'),'13:57:11'::time),'FMMonth DD, YYYY at
HH:MI pm');
to_char
-----------------------------
August 21, 2000 at 01:57 am
(1 row)

swingwire=# select
to_char(timestamp(date('now'),'14:57:11'::time),'FMMonth DD, YYYY at
HH:MI pm');
to_char
-----------------------------
August 21, 2000 at 02:57 pm
(1 row)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2000-08-22 04:20:30 Re: PostgreSQL BugTool Submission
Previous Message pgsql-bugs 2000-08-21 20:24:02 PostgreSQL BugTool Submission