Try:
update foo set timestamp_field = timestamp_field + '365
days'::interval;
John Goetsch wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org