Postgres Pro
Downloads
Home   >   mailing lists

Re: how to add 'time with time zone' data types and 'interval' data types - Mailing list pgsql-novice

From Binand Sethumadhavan
Subject Re: how to add 'time with time zone' data types and 'interval' data types
Date
Msg-id CAFBJCCY47XWoZgpcAuhK93+cNdhkVmy2_3wFPr8i6bOa6dCZ6A@mail.gmail.com
Whole thread Raw
In response to Re: how to add 'time with time zone' data types and 'interval' data types  (avpro avpro <avprowebeden@gmail.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: avpro avpro
Date:
Subject: Re: how to add 'time with time zone' data types and 'interval' data types
Next
From: Kevin Grittner
Date:
Subject: Re: how to add 'time with time zone' data types and 'interval' data types