Alias Temporal Types

[JoshInnis]

The temporal instant types are:
— ZONED DATETIME
A material value of ZONED DATETIME is called a zoned datetime. A zoned datetime represents a
temporal instant capturing the date, the time, and the time zone displacement.
NOTE 90 — Equivalent to TIMESTAMP WITH TIME ZONE with nanosecond precision in SQL.
— LOCAL DATETIME
A material value of LOCAL DATETIME is called a local datetime. A local datetime represents a tem�poral instant capturing the date and the time, but not the time zone displacement.
NOTE 91 — Equivalent to TIMESTAMP WITHOUT TIME ZONE with nanosecond precision in SQL.
— DATE
A material value of DATE is called a date. A date represents a temporal instant capturing the date,
but not the time, nor the time zone displacement.
NOTE 92 — Equivalent to DATE in SQL.
— ZONED TIME
A material value of ZONED TIME is called a zoned time. A zoned time represents a temporal instant
capturing the time of day and the time zone displacement, but not the date.
NOTE 93 — Equivalent to TIME WITH TIME ZONE with nanosecond precision in SQL.
— LOCAL TIME
A material value of LOCAL TIME is called a local time. A local time represents a temporal instant
capturing the time of day, but not the date, nor the time zone displacement.
NOTE 94 — Equivalent to TIME WITHOUT TIME ZONE with nanosecond precision in SQL.
A datetime is either a zoned datetime or a local datetime and a time is either a zoned time or a local time

--- DURATION
Interval Alias