Problem w/ date calculation. - Mailing list pgsql-general

Hi all,

I'm having a problem with a date calculation.  I'm trying to get a list of
all records who's "last_backed_up" field indicates one day or older.

But, I'm doing something wrong with age().

For example, if the current date is:
mapping=# select now();
             now
------------------------------
 2002-11-06 16:16:09.62247-07
(1 row)

Then the age of a field containing 2002-11-05 17:25:33.89754-07 should be
about 23 hours, right?

Well:
mapping=# select age(timestamp '2002-11-05 17:25:33.89754-07');
      age
----------------
 06:34:26.10246
(1 row)

What am I missing?

TIA.

--
Mike Diehl
Network Tools Devl.
SAIC at Sandia Labs
(505) 284-3137