Richlewis
Reputation: 15374
Update current timestamp plus x amount of days
If I have a column of membership_expiry_date TIMESTAMP (postgresql) and want to get the current expiry date and add 3 days to it, how would I write this query
UPDATE users SET membership_expiry_date = ??
How do I retrieve the current value and add to it?
Upvotes: 0
Views: 849
Answers (1)
maririna
Reputation: 51
UPDATE users
SET membership_expiry_date = membership_expiry_date + 3* INTERVAL '1 day'
Upvotes: 1
Related Questions
- Automatically populate a timestamp field in PostgreSQL when a new row is inserted
- How to add a time to an existing timestamp in Postgresql/sql?
- Postgres: Update date and retain time from timestamp
- Update table based on time difference between consecutive rows
- Postgres, Update TIMESTAMP to current date but preserve time of day
- PostgreSQL automatically update row at specific date
- How to update column with an increasing timestamp
- Updating a column in postgresql based on a specific date
- Adding interval to current timestamp in PostgreSQL
- Updating timestamp column by adding value from other column