Date Modifiers
sql
1-- Add 7 days
2SELECT DATETIME('now', '+7 days');
3
4-- Subtract 1 month
5SELECT DATETIME('now', '-1 month');
6
7-- Start of month
8SELECT DATETIME('now', 'start of month');Examples
sql
1SELECT DATETIME('now', '+1 year');
2SELECT DATETIME('now', '-30 days');