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
44". Seems bogus to me, but am I and the OP missing something?
EnterpriseDB UK: http://www.enterprisedb.com
pgsql-bugs by date
|Next:||From: Stefan Bähring||Date: 2009-09-28 08:21:55|
|Subject: Re: BUG #5081: ON INSERT rule does not work correctly|
|Previous:||From: Yaming Gu||Date: 2009-09-28 06:51:23|
|Subject: 答复: [BUGS] Encounter shared memo?==?utf-8?Q?ry error when running createlang?==?utf-8?Q? command!|