to_char issue?

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: to_char issue?
Date: 2009-09-28 07:53:13
Message-ID: 937d27e10909280053l4e15d6a0j7db99773e3f9dfad@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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?

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stefan Bähring 2009-09-28 08:21:55 Re: BUG #5081: ON INSERT rule does not work correctly
Previous Message Yaming Gu 2009-09-28 06:51:23 答复: [BUGS] Encounter shared memory error when running createlang command!