Using interval to add days to date time field Posgres

adding_days_to_fields_use_interval

# say you want to extend the expiration date for subscription service to 14 days, in postgres you can do that by

update users set expiration_date = expiration_date + interval '14 days'; # users is the table where expiration is stored

# I bet this could work, not tested

update users set expiration_date += interval '14 days';

# you could do so much more with interval > http://www.postgresqltutorial.com/postgresql-interval/