Re: Date Time Function / Age - Mailing list pgsql-general

From Tom Lane
Subject Re: Date Time Function / Age
Date
Msg-id 20225.1062084357@sss.pgh.pa.us
Whole thread Raw
In response to Date Time Function / Age  (Alex <alex@meerkatsoft.com>)
List pgsql-general
Alex <alex@meerkatsoft.com> writes:
> is there an easy way to get the Difference between 2 dates in Days... as
> an integer?

Subtract 'em ...

regression=# select '2002-01-01'::date - '2001-01-01'::date;
 ?column?
----------
      365
(1 row)


            regards, tom lane

pgsql-general by date:

Previous
From: "Ivar"
Date:
Subject: Re: Functions have 32 args limt ???
Next
From: "Ivar"
Date:
Subject: Re: Functions have 32 args limt ???