OperatorDescription and CommentsExample
DATE + INT => DATEAdd a number of days to the given datedate '2022-12-31' + integer '365'
=> 2023-12-31 as DATE
DATE + TIME => TIMESTAMPAdd the time of the day to a given datedate '2022-12-31' + time '01:00:00'
=> 2022-12-31 01:00:00 as TIMESTAMP
DATE - DATE => INTReturn the number of days between two datesdate '2022-12-12' - date '2022-01-31'
=> 315 as INT
DATE - INT => DATESubtract days from a given datedate '2022-12-12' - integer '4'
=> 2022-12-08 as DATE