Date Math - Mailing list pgsql-general

From John Goetsch
Subject Date Math
Date
Msg-id 1057775961.24399.46.camel@lap.seacode.com
Whole thread Raw
List 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



pgsql-general by date:

Previous
From: Don Isgitt
Date:
Subject: Failing ODBC connection
Next
From: Don Isgitt
Date:
Subject: Re: Failing ODBC connection