Curious age() behavior Cont'd

From: "Mitch Vincent" <mitch(at)venux(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Curious age() behavior Cont'd
Date: 2000-10-10 18:32:30
Message-ID: 016c01c032e8$731d37b0$0200000a@doot
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I should point out that it works as I expected it to on other values..

hhs=# SELECT age('Sun Nov 05 08:00:00 2000 EST','Tue Oct 10 08:00:00 2000
EDT') as esec;
esec
------------------
@ 26 days 1 hour
(1 row)

hhs=# SELECT ('Tue Oct 10 08:00:00 2000 EDT'::timestamp + '1 mon 24 days 1
hour'::interval);
?column?
------------------------------
Mon Dec 04 08:00:00 2000 EST
(1 row)

*shrug*

Thanks again..

-Mitch

Browse pgsql-general by date

  From Date Subject
Next Message Adam Ruth 2000-10-10 18:34:18 Re: Some advanced database features, are they present in PostgreSQL
Previous Message Mitch Vincent 2000-10-10 18:28:42 Curious age() behavior