Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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:


pgsql-bugs by date

Next:From: Stefan BähringDate: 2009-09-28 08:21:55
Subject: Re: BUG #5081: ON INSERT rule does not work correctly
Previous:From: Yaming GuDate: 2009-09-28 06:51:23
Subject: 答复: [BUGS] Encounter shared memo?==?utf-8?Q?ry error when running createlang?==?utf-8?Q? command!

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group