Search Postgresql Archives

How to return an INT4 subtracting dates?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: postgresql Forums <pgsql-general@xxxxxxxxxxxxxx>
Subject: How to return an INT4 subtracting dates?
From: Andre Lopes <lopes80andre@xxxxxxxxx>
Date: Wed, 9 Jun 2010 11:57:59 +0100

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,

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: How to return an INT4 subtracting dates?
  - From: Raymond O'Donnell
- Re: How to return an INT4 subtracting dates?
  - From: Pavel Stehule

Prev by Date: Re: Cognitive dissonance
Next by Date: Re: How to return an INT4 subtracting dates?
Previous by thread: How to show the current schema or search path in the psql PROMP
Next by thread: Re: How to return an INT4 subtracting dates?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux