Curious age() behavior Cont'd - Mailing list pgsql-general

From Mitch Vincent
Subject Curious age() behavior Cont'd
Date
Msg-id 016c01c032e8$731d37b0$0200000a@doot
Whole thread Raw
List 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




pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Curious age() behavior
Next
From: Lamar Owen
Date:
Subject: Re: [ADMIN] PostgreSQL encoding question