Thomas' Tech Tips

Add N days to current date in PostgreSQL

3 May 2023 - Thomas Damgaard

One thing that I have been asked quite frequently is “How do I add 1 day to now()?” in PostgreSQL?

This is rather easy using PostgreSQL’s interval operator:

date + interval → timestamp

Example: How to add 1 day to current date/time:

postgres=# SELECT NOW() + INTERVAL '1 day';
 2023-04-28 08:48:17.944839+02
(1 row)


Example use: Add 7 day to current date:

postgres=# SELECT CURRENT_DATE + INTERVAL '7 days';
 2023-05-04 00:00:00
(1 row)


In addition to basic arithmetic operations, interval types can be used in combination with various date/time functions to manipulate timestamps and perform more complex calculations. The interval type provides a flexible and convenient way to work with durations of time in PostgreSQL.

Filed under: howto, postgresql, sql, tips

Back to article list