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