On 09/06/2010 11:57, Andre Lopes wrote:
> Hi,
>
> I need to return an int4 subtracting two dates, but returns me an interval.
>
> select
> end_date - now() as interger_number
> from hist_anuncios
>
> How to return an integer out of this?
Hmmm, according to the docs, subtracting dates returns an integer:
http://www.postgresql.org/docs/8.4/static/functions-datetime.html
Try "current_date", which gives you a date, instead of "now", which
gives you a timestamp.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie