...
Comparisons with other tools
| SQL 2003 | Oracle | Sybase | Postgres | MySQL | Microsoft SQL | IBM DB2 | Presto | Snowflake | Hive >= 3.1 | Iceberg | Spark | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| timestamp | Local | Local | Local | Local | Instant | Other | Local | Local | Local | Local | Local | Instant |
| timestamp with local time zone | Instant | Instant | Instant | |||||||||
| timestamp with time zone | Offset | Offset | Offset | Instant | Offset | Offset | Offset | Instant | ||||
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.
...