Re: [HACKERS] to_char("HH12") with intervals

2010-02-23 Thread Bruce Momjian
Bruce Momjian wrote: > bruce wrote: > > bruce wrote: > > > Dave Page wrote: > > > > This was posted as a documentation comment: > > > > > > > > to_char(interval '0d 0h 12m 44s', 'DD HH MI SS'); > > > > with HH and HH12 will return 12 instead of 0. > > > > > > > > Testing on 8.4.1, it does seem to

[HACKERS] to_char("HH12") with intervals

2010-02-22 Thread Bruce Momjian
bruce wrote: > bruce wrote: > > Dave Page wrote: > > > This was posted as a documentation comment: > > > > > > to_char(interval '0d 0h 12m 44s', 'DD HH MI SS'); > > > with HH and HH12 will return 12 instead of 0. > > > > > > Testing on 8.4.1, it does seem to be the case that you get "00 12 12 > >