Postgres Pro
Downloads
Home   >   mailing lists

Date interval - Mailing list pgsql-sql

From Richard Sydney-Smith
Subject Date interval
Date
Msg-id 002901c383ed$a70423a0$8f601ad3@athlon2000
Whole thread Raw
Responses Re: Date interval  (Tomasz Myrta <jasiek@klaster.net>)
Re: Date interval  (sad <sad@bankir.ru>)
List pgsql-sql
Tree view
I am looking for a way to convert an interval into a number of days ( integer);
 
In sybase I would use :
 
days(today()-r_expire)
 
where r_expire is the timestamp I am comparing against.
 
How do we do this in postgres?
 
date_trunc(today()-r_expire) does not seem to do it
 
thanks
 
Richard
 

pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Case Insensitive comparison
Next
From: Tomasz Myrta
Date:
Subject: Re: Date interval