Postgres Pro
Downloads
Home   >   mailing lists

should have been HH12:MI, but bug is there anyway - Mailing list pgsql-bugs

From Sam Hokin
Subject should have been HH12:MI, but bug is there anyway
Date
Msg-id Pine.LNX.4.21.0010210036550.1106-100000@cb54085-b.mdsn1.wi.home.com
Whole thread Raw
List pgsql-bugs
Tree view 
Sorry, I mistyped that query in my bug report, damaging its credibility,
but the bug is actually there when you use "MI" for minutes:

template1=# select to_char(timestamp '2000-01-01 13:45:00', 'HH12:MI pm');
 to_char
----------
 01:45 am

---------
Sam Hokin ..... mailto:sam@bsharp.org .... http://www.bsharp.org/sam

pgsql-bugs by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: The Data Base System is in recovery mode
Next
From: Sam Hokin
Date:
Subject: bug in to_char(timestamp, text) for times between 12:00 and 14:00