On Thu, Aug 28, 2003 at 23:09:44 +0900,
Alex <[EMAIL PROTECTED]> wrote:
> Hi,
> is there an easy way to get the Difference between 2 dates in Days... as
> an integer?
>
> age('date1','date2') results in x years y days or something similar.
> but I would like to
> have the result in number of
Alex <[EMAIL PROTECTED]> writes:
> is there an easy way to get the Difference between 2 dates in Days... as
> an integer?
Subtract 'em ...
regression=# select '2002-01-01'::date - '2001-01-01'::date;
?column?
--
365
(1 row)
regards, tom lane
Hi,
is there an easy way to get the Difference between 2 dates in Days... as
an integer?
age('date1','date2') results in x years y days or something similar.
but I would like to
have the result in number of days as an integer.
Thanks for your help
Alex
---(end of br
