Re: Subtraction of Dates

try date_mi as opposed to direct subtraction.

eg:

edb=# select version();
version
---------------------------------------------------------------
PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.95.2
(1 row)

edb=# select date_mi('2002-06-24','2002-06-21');
date_mi
---------
3
(1 row)

Steve

> -----Original Message-----
> From: Valerie Goodman [mailto:VGoodman(at)aih(dot)co(dot)uk]
> Sent: 27 June 2002 14:22
> To: pgsql-sql(at)postgresql(dot)org
> Subject: [SQL] Subtraction of Dates
>
>
>
> When I want an integer for a number of days between two dates, direct
> subtraction of two dates returns an integer.
>
> However, age function returns an interval.
>
> Which is the correct method to use and if age is the correct
> method, how do
> I convert that to the number of days?
>
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>