THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
| Type | Value in America/Los_Angeles | Value in America/New_York |
|---|---|---|
| timestamp | 2014-12-12 12:34:56 | 2014-12-12 12:34:56 |
| timestamp with local time zone | 2014-12-12 12:34:56 | 2014-12-12 15:34:56 |
Comparisons with other tools
| SQL 2003 | Oracle | Sybase | Postgres | MySQL | Microsoft SQL | IBM DB2 | Presto | Snowflake | Hive >= 3.1 | Spark | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| timestamp | Local | Local | Local | Local | Instant | Other | Local | Local | Local | Local | Instant |
| timestamp with local time zone | Instant | Instant | Instant | ||||||||
| timestamp with time zone | Offset | Offset | Offset | Instant | Offset | Offset | Offset | ||||
timestamp without time zone | Local | Local | Local | Local |
Other definitions:
- Offset = Recording a point in time as well as the time zone offset in the writer's time zone.
Built In Operators and Functions
...