Re: DateDiff in PostgreSQL - Mailing list pgsql-sql

From Rod Taylor
Subject Re: DateDiff in PostgreSQL
Date
Msg-id 1068213347.42603.2.camel@jester
Whole thread Raw
In response to DateDiff in PostgreSQL  ("George A.J" <jinujosein@yahoo.com>)
List pgsql-sql
> ie, a function that returns difference of two dates(timestamp) in days
> or months or year..
> 
> The - operator for timestamp retuns the intervel in days only.

rbt=# select extract('days' from current_timestamp -
'2003-01-01'::timestamp);date_part
-----------      310
(1 row)



pgsql-sql by date:

Previous
From: "George A.J"
Date:
Subject: Re: DateDiff in PostgreSQL
Next
From: Christopher Browne
Date:
Subject: Re: SQL to PLC to diverter gate, can this be done?