Shift a date or timestamp forward or backward.
Section: Date and Time Functions
Add an interval
sql
sql
SELECT created_at, created_at + INTERVAL '7 days' AS plus_seven_days
FROM orders;Explanation
Interval syntax varies slightly across engines.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Date and Time Functions
Get current date and timestamp
Return the current date and current timestamp.
Extract date parts
Return year, month, day, and other pieces from a date or timestamp.