Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Tom LaneDate: 2000-08-22 04:20:30
Subject: Re: PostgreSQL BugTool Submission
Previous:From: pgsql-bugsDate: 2000-08-21 20:24:02
Subject: PostgreSQL BugTool Submission

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group