By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| now |
|---|
| 2024-02-07 08:08:46.000475+00 |
SELECT 1
SET
| now |
|---|
| 2024-02-07 09:08:46.002342+01 |
SELECT 1
SET
| timezone |
|---|
| 2024-02-07 08:08:46.002841 |
SELECT 1
SET
CREATE TABLE
| ts | tstz | ts at tz | tstz at tz |
|---|---|---|---|
| 2024-02-07 12:00:00 | 2024-02-07 11:00:00+00 | 2024-02-07 12:00:00+00 | 2024-02-07 11:00:00 |
| 2024-02-07 12:00:00 | 2024-02-07 10:00:00+00 | 2024-02-07 12:00:00+00 | 2024-02-07 10:00:00 |
| 2024-02-07 12:00:00 | 2024-02-07 09:00:00+00 | 2024-02-07 12:00:00+00 | 2024-02-07 09:00:00 |
| 2024-02-07 12:00:00 | 2024-02-07 08:00:00+00 | 2024-02-07 12:00:00+00 | 2024-02-07 08:00:00 |
INSERT 0 4
SET
| ts | tstz | ts at tz | tstz at tz |
|---|---|---|---|
| 2024-02-07 12:00:00 | 2024-02-07 22:00:00+11 | 2024-02-07 12:00:00+11 | 2024-02-07 22:00:00 |
| 2024-02-07 12:00:00 | 2024-02-07 21:00:00+11 | 2024-02-07 12:00:00+11 | 2024-02-07 21:00:00 |
| 2024-02-07 12:00:00 | 2024-02-07 20:00:00+11 | 2024-02-07 12:00:00+11 | 2024-02-07 20:00:00 |
| 2024-02-07 12:00:00 | 2024-02-07 19:00:00+11 | 2024-02-07 12:00:00+11 | 2024-02-07 19:00:00 |
SELECT 4