github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/eval/at_time_zone (about) 1 # Regression test for cockroachdb-django#97. 2 eval 3 '2001-01-01 01:00:00'::timestamptz AT TIME ZONE '+3' 4 ---- 5 '2000-12-31 22:00:00+00:00' 6 7 eval 8 '2001-01-01 01:00:00'::timestamptz AT TIME ZONE '-3:00' 9 ---- 10 '2001-01-01 04:00:00+00:00' 11 12 eval 13 '2001-01-01 01:00:00'::timestamptz AT TIME ZONE 'GMT+3' 14 ---- 15 '2000-12-31 22:00:00+00:00' 16 17 eval 18 '2001-01-01 01:00:00'::timestamptz AT TIME ZONE 'UTC-3:00' 19 ---- 20 '2001-01-01 04:00:00+00:00' 21 22 eval 23 '2001-01-01 01:00:00'::timestamptz AT TIME ZONE '-3:00' 24 ---- 25 '2001-01-01 04:00:00+00:00' 26 27 eval 28 '2001-01-01 01:00:00'::timestamptz AT TIME ZONE 'Pacific/Honolulu' 29 ---- 30 '2000-12-31 15:00:00+00:00' 31 32 eval 33 '2001-01-01 01:00:00'::timestamp AT TIME ZONE '+3' 34 ---- 35 '2001-01-01 04:00:00+00:00' 36 37 eval 38 '2001-01-01 01:00:00'::timestamp AT TIME ZONE '-3:00' 39 ---- 40 '2000-12-31 22:00:00+00:00' 41 42 eval 43 '2001-01-01 01:00:00'::timestamp AT TIME ZONE 'GMT+3' 44 ---- 45 '2001-01-01 04:00:00+00:00' 46 47 eval 48 '2001-01-01 01:00:00'::timestamp AT TIME ZONE 'UTC-3:00' 49 ---- 50 '2000-12-31 22:00:00+00:00' 51 52 eval 53 '2001-01-01 01:00:00'::timestamp AT TIME ZONE 'Pacific/Honolulu' 54 ---- 55 '2001-01-01 11:00:00+00:00' 56 57 # Regression test for #44027. 58 # Attempt to convert string to AT TIME ZONE. An implicit cast should also work with this. 59 eval 60 '2001-01-01 01:00:00' AT TIME ZONE 'GMT+3' 61 ---- 62 '2000-12-31 22:00:00+00:00'