Re: [BUGS] Bugs in to_char function

2000-10-18 Thread Karel Zak
On Tue, 17 Oct 2000, Tom Lane wrote: > "Tom Rogers" <[EMAIL PROTECTED]> writes: > > [to_char] gives the correct meridian value for all AM times but incorrectly > > returns an AM meridian for PM times between 12:00 PM and 1:50:59 PM. > > I believe this is a known bug in the 7.0 implementation of

Re: [BUGS] Bugs in to_char function

2000-10-18 Thread Karel Zak
On Tue, 17 Oct 2000, Tom Rogers wrote: > I wanted to include the following in a select statement: > > to_char(departtime, 'HH12:MI PM') as xdepart Very old story and already fixed in the current CVS. Wait for great 7.1 :-) Karel PS. has this list so

Re: [BUGS] Bugs in to_char function

2000-10-17 Thread Tom Lane
"Tom Rogers" <[EMAIL PROTECTED]> writes: > [to_char] gives the correct meridian value for all AM times but incorrectly > returns an AM meridian for PM times between 12:00 PM and 1:50:59 PM. I believe this is a known bug in the 7.0 implementation of to_char, and is long since fixed in development