Postgres Pro
Downloads
Home   >   mailing lists

Re: age command - Mailing list pgsql-general

From Tom Lane
Subject Re: age command
Date
Msg-id 25542.1029248382@sss.pgh.pa.us
Whole thread Raw
In response to age command  (Jan Theofel <theofel@etes.de>)
List pgsql-general
Tree view 
Jan Theofel <theofel@etes.de> writes:
> But what I need is the total difference in days as integer.

Subtract the dates.

regression=# select date('2002-08-13') - date('2002-07-13');
 ?column?
----------
       31
(1 row)

            regards, tom lane

pgsql-general by date:

Previous
From: "Peter Darley"
Date:
Subject: Re: Vacuum problem
Next
From: Gregory Seidman
Date:
Subject: Re: Stored procedures returning rowsets