Hi,
I want to find out if there's a method to change this
select to_char('1 day 09:18:42.37996'::interval,'HH24:MI:SS')
to something like
24+9(hours) = 33:18:42 instead of returning It as 09:19:42
I've not found a way to do this (yet)
--
Sent via pgsql-general mailing list
On 21/08/2008 10:09, Ow Mun Heng wrote:
I want to find out if there's a method to change this
select to_char('1 day 09:18:42.37996'::interval,'HH24:MI:SS')
to something like
24+9(hours) = 33:18:42 instead of returning It as 09:19:42
I had to do something like this recently when adding up
On 2008-08-21 11:09, Ow Mun Heng wrote:
I want to find out if there's a method to change this
select to_char('1 day 09:18:42.37996'::interval,'HH24:MI:SS')
to something like
24+9(hours) = 33:18:42 instead of returning It as 09:19:42
That's because 1 day doesn't always have 24 hours, because
On Thu, 2008-08-21 at 11:53 +0200, Tomasz Ostrowski wrote:
On 2008-08-21 11:09, Ow Mun Heng wrote:
I want to find out if there's a method to change this
select to_char('1 day 09:18:42.37996'::interval,'HH24:MI:SS')
to something like
24+9(hours) = 33:18:42 instead of returning It as