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 Kevin Grittner
Subject Re: how to add 'time with time zone' data types and 'interval' data types
Date
Msg-id 1389111401.40691.YahooMailNeo@web122301.mail.ne1.yahoo.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>)
Responses Re: how to add 'time with time zone' data types and 'interval' data types
Re: how to add 'time with time zone' data types and 'interval' data types
List pgsql-novice
Tree view 
avpro avpro <avprowebeden@gmail.com> wrote:

> select '12:00'::time - '9:00'::time; didn't work.

I get this on 9.3:

test=# select '12:00'::time - '9:00'::time;
 ?column?
----------
 03:00:00

(1 row)
What version are you using?  What happens when you try it?

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-novice by date:

Previous
From: Binand Sethumadhavan
Date:
Subject: Re: how to add 'time with time zone' data types and 'interval' data types
Next
From: Sameer Kumar
Date:
Subject: Re: Master-slave failover question