| From: | "John D(dot) Burger" <john(at)mitre(dot)org> |
|---|---|
| To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: date time function |
| Date: | 2007-06-29 18:17:35 |
| Message-ID: | C4E2800F-7F62-4526-8739-CB08DD78B22B@mitre.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I can't anything in the docs that explain how intervals print out.
They seem to show like this:
> select now() - '1990-01-01';
?column?
-------------------------------
6388 days 13:06:26.3605600595
or like this:
> select now() - current_date;
?column?
-----------------
14:06:46.119788
unless you use age(), which supposedly also returns an interval:
> select age(now(), '1990-01-01');
age
-----------------------------------------
17 years 5 mons 28 days 14:08:04.524803
Why do the first and third intervals print out differently? I see
this in the docs for age:
Subtract arguments, producing a "symbolic" result that uses years
and months
But age() is documented as simply producing an interval - where is
the magic that makes the first and third results above look
different? Ah, wait a minute - does this have to do with the varying
number of days in different months?
Thanks.
- John D. Burger
MITRE
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannes Dorbath | 2007-06-29 18:24:02 | Re: db replication |
| Previous Message | Erik Jones | 2007-06-29 17:47:07 | Re: Standby servers and incrementally updated backups |