how to add 'time with time zone' data types and 'interval' data types

From: avpro avpro <avprowebeden(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: how to add 'time with time zone' data types and 'interval' data types
Date: 2014-01-06 19:06:04
Message-ID: CAAQdDnkJTUNhyj4GQAgPW6u7H6MCPHEQTR_FfJxZG2rESTdOBA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hi all,

1st scenario: i have a table with two fields both of them ''time with time
zone'. How could I add them? i would like to have something like: SELECT
table.field1 + table.field2 as sum;
2nd scenario, similar but this time data types are 'interval': i have a
table with two fields both of them ''interval'. How could I add them? i
would like to have something like: SELECT table.field1 + table.field2 as
sum;

thanks for your hint,
John.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2014-01-06 19:38:03 Re: how to add 'time with time zone' data types and 'interval' data types
Previous Message Magnus Persson 2014-01-05 16:28:41 Re: Returning NULL from SRF