| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: function to find difference between in days between two dates |
| Date: | 2007-06-14 07:39:31 |
| Message-ID: | 162867790706140039j569676a3na70918a65e542f58@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
2007/6/14, A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com>:
> am Thu, dem 14.06.2007, um 11:56:15 +0530 mailte Ashish Karalkar folgendes:
> > Hello all,
> >
> > Is there any function to find differences in days between two dates?
>
> Yes, age().
>
>
there is difference
date - date --> integer
age(date::timestamp, date::timestamp) --> interval
regards
Pavel
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2007-06-14 07:41:29 | Re: [SQL] setof or array as input parameter to postgresql 8.2 functions |
| Previous Message | PFC | 2007-06-14 07:24:54 | Re: pointer to feature comparisons, please |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2007-06-14 07:41:29 | Re: [SQL] setof or array as input parameter to postgresql 8.2 functions |
| Previous Message | Manso Gomez, Ramon | 2007-06-14 07:03:48 | Re: [SQL] setof or array as input parameter to postgresql 8.2 functions |