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@aih.co.uk]
> Sent: 27 June 2002 14:22
> To: pgsql-sql@postgresql.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
> 
>