Operators

+

addition

-

subtraction

*

multiplication

/

division

ts + i

adds i seconds to ts

ts - i

subtracts i seconds from ts

ts - ts

computes difference in seconds,
treated as unix_timestamp, converted to timestamp

=

equal

!= or <>

not equal

>

greater than

>=

greater or equal to

<

less than

<=

less than or equal to

::

Explicit cast expression::data_type