Alias Temporal Types
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 temporal 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