Sql - Time Zone

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Relation|Table) - Tabular data > Structured Query Language (SQL)

1 - 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).

2 - 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.

3 - Documentation / Reference

  • Julian Hyde - Calcite Mailing list