Supported Date/Time Types

May 23, 2018 · View on GitHub

Timestamp

Types

timestamp

Functions

Relational operators: !=, <>, =, <=, <, >, >=
- BETWEEN x AND y
- NOT BETWEEN x AND y
- BETWEEN SYMMETRIC x AND y
- NOT BETWEEN SYMMETRIC x AND y
- IS DISTINCT FROM b
- IS NOT DISTINCT FROM b
- expression IS NULL
- expression IS NOT NULL
- expression ISNULL
- expression NOTNULL
date_part with the 'field' argument being 'year'