Description
The TIMESTAMP WITH LOCAL TIME ZONE data type is a variant of TIMESTAMP that includes a time zone offset in its value. Data stored in the database is normalized to the database time zone (UTC) and time zone offset is not stored as part of the column data. When the data is retrieved, it to be returned in the user's local session time zone.
i.e:
CREATE TABLE timestamp(ts TIMESTAMP, t_tz TIMESTAMP WITH LOCAL TIME ZONE);
SET TIME ZONE 'tz1';
INSERT INTO timestamp VALUES ('2011-01-01 01:01:01', TIMESTAMP WITH LOCAL TIME ZONE '2011-01-01 01:01:01');
SET TIME ZONE 'tz2';
INSERT INTO timestamp VALUES ('2011-01-01 01:01:01', TIMESTAMP WITH LOCAL TIME ZONE '2011-01-01 01:01:01');
...
select * from timestamp;
returned rows need to be different in case of different tz1 and tz2 offsets but they are equals for now. Also returned representation need to be present in user session time zone.
Update from 26.02.2024:
Definition of done for this task:
- Client time zone is passed to server (check other database implementations to decide how and when to pass it).
- Data of type "TIMESTAMP With LOCAL TIME ZONE" can be written/read correctly using the dynamic parameter.
Attachments
Issue Links
- is blocked by
-
IGNITE-21567 Sql. Conversion from TIMESTAMP to TIMESTAMP_WITH_LOCAL_TIME_ZONE trims millis
-
- Resolved
-
- is related to
-
IGNITE-19371 Sql. Forbid TIME_WITH_LOCAL_TIME_ZONE and TIMESTAMP_WITH_LOCAL_TIME_ZONE data types.
-
- Resolved
-
-
-
- Resolved
-
- relates to
-
-
- Open
-
-
-
- Open
-
- links to
