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
 

Reply via email to