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

On 7 January 2014 20:58, avpro avpro <avprowebeden@gmail.com> wrote:
> select '12:00'::time - '9:00'::time; didn't work.

This ought to work, oughtn't it?

binand=# select '12:00'::time - '9:00'::time as duration;
 duration
----------
 03:00:00
(1 row)

Binand