116. DATETIME Modifiers

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');

1SELECT DATETIME('now', '+1 year');
2SELECT DATETIME('now', '-30 days');