On Aug 8, 2005, at 4:23 PM, Lane Van Ingen wrote:
> I am trying to do some simple date arithmetic. All I wanted to do
> is take a
> timestamp
> (example: 2005-08-08 16:15:30) without a timezone, and substract a
> computed
> number
> of minutes and seconds (such as 310 seconds) from it; keep running
> into
> problems.
select '2005-08-08 16:15:30'::timestamp - '310 seconds'::interval;
?column?
---------------------
2005-08-08 16:10:20
(1 row)
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL