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: 937d27e10909280053l4e15d6a0j7db99773e3f9dfad@mail.gmail.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group