Date Math

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