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
|
- Re: [SQL] Date interval Richard Sydney-Smith
- Re: [SQL] Date interval Tomasz Myrta
- Re: [SQL] Date interval sad