Re: function to find difference between in days between two dates - Mailing list pgsql-sql

Hello

PostgreSQL hasn't any official function for it. If you need it, you
can write own function

CREATE FUNCTION date_diff(date, date) returns integer as $$
select $1-$2; $$ language sql;

Regards
Pavel Stehule

2007/6/14, Ashish Karalkar <ashish.karalkar@info-spectrum.com>:
>
>
> Hello all,
>
> Is there any function to find  differences in days between two dates?
>
>
> I am using
>
> select abs(current_date - '2007-06-15')
>
> to get the desired result.
> but I think there must be a function and I am missing it,
> if so, can anybody please point me to that.
>
>
> Thanks in advance
>
> With regards
> Ashish Karalkar
>
>
>