Date and Timestamp Operators

• date - date ➔ integer
• timestamptz - timestamptz ➔ interval
• date + integer ➔ date
• date + interval ➔ timestamp *
• timestamptz + interval ➔ timestamptz *

* Avoid year, month and other imprecise units.

Four Ways to Subtract Timestamps

1. timestamptz - timestamptz
2. timestamptz +/- interval
3. age function
4. epoch +/- epoch

Container Types

• Range
• Multirange
• Array
• Composite