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'