Re: [SQL] Bug in to_char()

2000-07-13 Thread Karel Zak
On Wed, 12 Jul 2000, Brian Powell wrote: > Greetings, > > Working with PostGreSQL 7.02, I found the following problem: PM/AM is already known bug and is already fixed in current CVS. In 7.1 it will correct. Karel

[SQL] Bug in to_char()

2000-07-12 Thread Brian Powell
Greetings, Working with PostGreSQL 7.02, I found the following problem: The AM/PM designator in the to_char function does not work proper for 13:00 and 12:00. See the following: test=> select to_char('3-12-2000 14:00'::timestamp, 'Dy, HH12:MI PM'); to_char --- Sun, 02:00 P