Date Math

From: John Goetsch <jg(at)seacode(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Date Math
Date: 2003-07-09 18:39:22
Message-ID: 1057775961.24399.46.camel@lap.seacode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am trying to modify some timestamps in the database and cannot find
documentation relating to date/timestamp manipulation.

What I am thinking of something like:

update foo set timestamp_field = timestamp_field + 365;

where the 365 is days, or seconds or something.

Any hints?

Thanks
john

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Luc Lachance 2003-07-09 18:48:18 Re: Date Math
Previous Message Don Isgitt 2003-07-09 18:35:19 Re: Failing ODBC connection