Datetime Operators
Datetime operators allow arithmetic operations on date and timestamp values. These operators enable adding or subtracting intervals from datetime values and calculating differences between datetime values.
Supported Operations
Operation | Result Type | Description |
|---|---|---|
| | Add an interval to a date |
| | Subtract an interval from a date |
| | Add an interval to a timestamp |
| | Subtract an interval from a timestamp |
| | Add an interval to another interval |
| | Subtract an interval from another interval |
| | Combine a date and time into a timestamp |
Examples
Adding Intervals to Dates
-- Example 1: Add days to a date > SELECT DATE '2025-01-15' + INTERVAL '10' DAY; 2025-01-25 00:00:00 -- Example 2: Add months to a date > SELECT DATE '2025-01-15' + INTERVAL '3' MONTH; 2025-04-15 00:00:00 -- Example 3: Add years to a date > SELECT DATE '2025-01-15' + INTERVAL '2' YEAR; 2027-01-15 00:00:00
Subtracting Intervals from Dates
-- Example 4: Subtract days from a date > SELECT DATE '2025-01-15' - INTERVAL '10' DAY; 2025-01-05 00:00:00 -- Example 5: Subtract months from a date > SELECT DATE '2025-01-15' - INTERVAL '3' MONTH; 2024-10-15 00:00:00 -- Example 6: Subtract years from a date > SELECT DATE '2025-01-15' - INTERVAL '2' YEAR; 2023-01-15 00:00:00
Adding Intervals to Timestamps
-- Example 7: Add hours to a timestamp > SELECT TIMESTAMP '2025-01-15 10:30:00' + INTERVAL '5' HOUR; 2025-01-15 15:30:00 -- Example 8: Add days and hours to a timestamp > SELECT TIMESTAMP '2025-01-15 10:30:00' + INTERVAL '1 12:00:00' DAY TO SECOND; 2025-01-16 22:30:00
Subtracting Intervals from Timestamps
-- Example 9: Subtract hours from a timestamp > SELECT TIMESTAMP '2025-01-15 10:30:00' - INTERVAL '5' HOUR; 2025-01-15 05:30:00 -- Example 10: Subtract days and hours from a timestamp > SELECT TIMESTAMP '2025-01-15 10:30:00' - INTERVAL '1 12:00:00' DAY TO SECOND; 2025-01-13 22:30:00
Combining Date and Time
-- Example 11: Combine date and time > SELECT DATE '2025-01-15' + TIME '14:30:00'; 2025-01-15 14:30:00