| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | "Rodolfo J(dot) Paiz" <rpaiz(at)simpaticus(dot)com> |
| Cc: | Alexander Borkowski <alexander(dot)borkowski(at)abri(dot)une(dot)edu(dot)au>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: SQL and function reference? |
| Date: | 2005-01-25 17:00:46 |
| Message-ID: | 20050125170046.GA51343@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Tue, Jan 25, 2005 at 10:07:35AM -0600, Rodolfo J. Paiz wrote:
>
> After a good 15 minutes of searching, I'm still looking for a way to use
> age() to get how many *days* ago something happened, expressed as an
> integer rather than an interval.
Subtracting two dates yields an integer (see the "Date/Time Operators"
table in the "Date/Time Functions and Operators" section of the
documentation). If you have timestamps then you could cast them
to date and then subtract. You could also use extract(epoch from
interval_value) to get the number of seconds in an interval, then
divide that by 86400 (24*60*60) to get days.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | M. Bastin | 2005-01-25 17:45:31 | Re: programming language for postgresql |
| Previous Message | Jason Dixon | 2005-01-25 16:55:33 | Re: recommended programming language for postgresql |