Interval Formatting -> Convert to timestamp

From: "Ow Mun Heng" <ow(dot)mun(dot)heng(at)wdc(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Interval Formatting -> Convert to timestamp
Date: 2008-08-21 09:09:38
Message-ID: 88C32A5D9FC71B4BB1B911B7B210496912AFFE6C@wdmyexbe03.my.asia.wdc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shashwat_Nigam 2008-08-21 09:12:13 Re: Regarding access to a user
Previous Message Tomasz Ostrowski 2008-08-21 09:07:03 Re: Regarding access to a user