Date/Time Functions and Operators
Date/Time Operators
Operator | Description and Comments | Example |
---|---|---|
DATE + INT => DATE | Add a number of days to the given date | date '2022-12-31' + integer '365' => 2023-12-31 as DATE |
DATE + TIME => TIMESTAMP | Add the time of the day to a given date | date '2022-12-31' + time '01:00:00' => 2022-12-31 01:00:00 as TIMESTAMP |
DATE - DATE => INT | Return the number of days between two dates | date '2022-12-12' - date '2022-01-31' => 315 as INT |
DATE - INT => DATE | Subtract days from a given date | date '2022-12-12' - integer '4' => 2022-12-08 as DATE |