Postgres Pro
Downloads
Home   >   mailing lists

How to return an INT4 subtracting dates? - Mailing list pgsql-general

From Andre Lopes
Subject How to return an INT4 subtracting dates?
Date
Msg-id AANLkTimzdwotUkXfX5SWT8-YalHEeKNs3lKQf2SsiwTV@mail.gmail.com
Whole thread Raw
Responses Re: How to return an INT4 subtracting dates?
Re: How to return an INT4 subtracting dates?
List pgsql-general
Tree view
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?


Best Regards,

pgsql-general by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Cognitive dissonance
Next
From: Pavel Stehule
Date:
Subject: Re: How to return an INT4 subtracting dates?