Re: subtracting minutes from date

From: "Brandon Metcalf" <bmetcalf(at)nortel(dot)com>
To: Chandra Sekhar Surapaneni <chandu(at)positivenetworks(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: subtracting minutes from date
Date: 2006-02-23 21:25:35
Message-ID: Pine.LNX.4.58L.0602231525290.30715@cash.rhiamet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

c == chandu(at)positivenetworks(dot)net writes:

c> You can just save it as timestamp and try the following query.

c> select * from table where date < (now() - interval '1 hour');

Thanks.

--
Brandon

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brandon Metcalf 2006-02-23 21:25:52 Re: subtracting minutes from date
Previous Message Ragnar 2006-02-23 21:14:58 Re: SQL TYPE MAP such as SQL_CHAR, SQL_NUMERIC , etc