Re: BUG #2056: to_char no long takes time as input? - Mailing list pgsql-bugs

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Oh, one more thing.  With the new patch I just posted, '0 hours' and
> 'HH' returns 12:

>     test=> select to_char('0 hours'::interval, 'HH');
>      to_char
>     ---------
>      12
>     (1 row)

Yeah, it's done that in every release since 7.2.  8.1.0 is the only
release that thinks 00 is correct.

            regards, tom lane