Date Arithmetic in PL/pgSql - Mailing list pgsql-novice

From Lane Van Ingen
Subject Date Arithmetic in PL/pgSql
Date
Msg-id EKEMKEFLOMKDDLIALABIKEBOCBAA.lvaningen@esncc.com
Whole thread Raw
Responses Re: Date Arithmetic in PL/pgSql  (John DeSoi <desoi@pgedit.com>)
List pgsql-novice
I am using pgplsql on Windows 2003, PostgreSQL 8.0.

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.

Have tried using age(), INTERVAL, and other different approaches. Does
anybody
have a clue how to make this work simply?



pgsql-novice by date:

Previous
From: babu
Date:
Subject: postgresql with ssl on windows
Next
From: John DeSoi
Date:
Subject: Re: Date Arithmetic in PL/pgSql