Sql - Time Zone

Data System Architecture

About

The SQL standard says that date-time values have no time zone.

Database API (such as JDBC and ODBC) converts zone-less date-time values into the local timezone when you call a method such as getDate(String).

Example

Consider the timestamp literal TIMESTAMP '1970-01-01 00:00:00'. In the database that has the value 0. But does it represent the epoch (1970-01-01 00:00:00 UTC)? No. There is no time zone.

Documentation / Reference

  • Julian Hyde - Calcite Mailing list







Share this page:
Follow us:
Task Runner