Re: [HACKERS] Possible age() bug?

2000-10-10 Thread Mitch Vincent
> 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

[HACKERS] Possible age() bug?

2000-10-10 Thread Mitch Vincent
Maybe I'm just overlooking something really simple but this has me a bit confused. What I'm trying to do is get the amount of time from A to B -- I thought age() would do just that but it seems to be about a day off sometimes. hhs=# SELECT age('Sun Dec 03 08:00:00 2000 EST','Tue Oct 10 08:00:00