github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/function/func_convert_tz.result (about)

     1  select convert_tz('2023-11-06 10:28:00','GMT', 'MET') as dtime;
     2  dtime
     3  2023-11-06 11:28:00
     4  select convert_tz('1999-06-06 10:28:00','MET','Europe/Moscow') as dtime;
     5  dtime
     6  1999-06-06 12:28:00
     7  select convert_tz('2020-05-09 10:28:00','Japan', 'Mexico/BajaNorte') as dtime;
     8  dtime
     9  2020-05-08 18:28:00
    10  select convert_tz('2023-08-06 10:28:00','MET','Europe/Moscow') as dtime;
    11  dtime
    12  2023-08-06 11:28:00
    13  select convert_tz('2007-09-11 02:00:00','America/Cambridge_Bay','GMT-0')as dtime;
    14  dtime
    15  2007-09-11 08:00:00
    16  select convert_tz('2000-10-06 10:28:00','GMT', 'UTC') as dtime;
    17  dtime
    18  2000-10-06 10:28:00
    19  select convert_tz('2003-12-06 10:28:00','CET','EST') as dtime;
    20  dtime
    21  2003-12-06 04:28:00
    22  select convert_tz('2023-12-31 10:28:00','+08:00', 'America/New_York') as dtime;
    23  dtime
    24  2023-12-30 21:28:00
    25  select convert_tz('2023-02-06 10:28:00','MET','Hongkong') as dtime;
    26  dtime
    27  2023-02-06 17:28:00
    28  select convert_tz('2023-03-11 02:00:00','Asia/Shanghai','+05:00')as dtime;
    29  dtime
    30  2023-03-10 23:00:00
    31  select convert_tz('2023-11-05 05:00:00','US/Eastern','US/Central')as dtime;
    32  dtime
    33  2023-11-05 04:00:00
    34  select convert_tz('2023-01-06 10:28:00','+08:00', '+10:00') as dtime;
    35  dtime
    36  2023-01-06 12:28:00
    37  select convert_tz('2023-02-06 10:28:00','+08:00', '+00:00') as dtime;
    38  dtime
    39  2023-02-06 02:28:00
    40  select convert_tz('2023-03-06 10:28:00','+08:00', '+05:00') as dtime;
    41  dtime
    42  2023-03-06 07:28:00
    43  select convert_tz('2023-04-26 10:28:00','+05:00', '+08:00') as dtime;
    44  dtime
    45  2023-04-26 13:28:00
    46  select convert_tz('2023-05-16 10:28:00','+00:00', '+08:00') as dtime;
    47  dtime
    48  2023-05-16 18:28:00
    49  select convert_tz('2023-06-01 10:28:00','+00:00', '+23:00') as dtime;
    50  dtime
    51  null
    52  select convert_tz('2023-07-06 10:28:00','+06:00', '+12:00') as dtime;
    53  dtime
    54  2023-07-06 16:28:00
    55  select convert_tz('2023-08-30 10:28:00','+12:00', '+06:00') as dtime;
    56  dtime
    57  2023-08-30 04:28:00
    58  select convert_tz('2020-09-19 19:59:00','+00:00', '+05:30') as dtime;
    59  dtime
    60  2020-09-20 01:29:00
    61  select convert_tz('2020-10-19 19:59:00','-05:00', '+05:30') as dtime;
    62  dtime
    63  2020-10-20 06:29:00
    64  select convert_tz('2010-11-01 12:00:00','+00:00','-07:00') as dtime;
    65  dtime
    66  2010-11-01 05:00:00
    67  select convert_tz('2010-12-30','+00:00','-07:00') as dtime;
    68  dtime
    69  2010-12-29 17:00:00
    70  select convert_tz(NULL,'-05:00', '+05:30') as dtime;
    71  dtime
    72  null
    73  select convert_tz('2023-11-06 10:28:00',NULL, '+08:00') as dtime;
    74  dtime
    75  null
    76  select convert_tz('2023-11-06 10:28:00','+00:00', NULL) as dtime;
    77  dtime
    78  null
    79  select convert_tz('9999-12-31 23:59:59','+08:00', '+12:30') as dtime;
    80  dtime
    81  9999-12-31 23:59:59
    82  select convert_tz('0001-01-01 00:00:01','+00:00', '-5:30') as dtime;
    83  dtime
    84  0001-01-01 00:00:01
    85  select convert_tz('2023-11-06 10:28:00','+00:00', '11111') as dtime;
    86  dtime
    87  null
    88  select convert_tz('2023-11-06 10:28:00','+00:aa', '+08:00') as dtime;
    89  dtime
    90  null
    91  select convert_tz('2023-11','+00:00', '+08:00') as dtime;
    92  invalid input: invalid datetime value 2023-11
    93  create table convert_table(c1 datetime,c2 date,c3 timestamp(3));
    94  insert into convert_table values('2010-09-26','2022-01-02 10:02:00','2021-05-02 12:02:00.0923'),('2011-02-20 10:02:00','2020-01-02','2021-05-02'),('2019-03-16 11:12:00','2022-01-02 10:02:00','2021-05-02 12:02:00.0923');
    95  select convert_tz(c1,'+00:00', '+08:00'),c1 from convert_table;
    96  convert_tz(c1,'+00:00', '+08:00')    c1
    97  2010-09-26 08:00:00    2010-09-26 00:00:00
    98  2011-02-20 18:02:00    2011-02-20 10:02:00
    99  2019-03-16 19:12:00    2019-03-16 11:12:00
   100  select convert_tz(c2,'+00:00', '+08:00'),c2 from convert_table;
   101  convert_tz(c2,'+00:00', '+08:00')    c2
   102  2022-01-02 08:00:00    2022-01-02
   103  2020-01-02 08:00:00    2020-01-02
   104  2022-01-02 08:00:00    2022-01-02
   105  select convert_tz(c3,'+00:00', '+08:00'),c3 from convert_table;
   106  convert_tz(c3,'+00:00', '+08:00')    c3
   107  2021-05-02 20:02:00    2021-05-02 12:02:00.092000000
   108  2021-05-02 08:00:00    2021-05-02 00:00:00
   109  2021-05-02 20:02:00    2021-05-02 12:02:00.092000000
   110  select convert_tz(str_to_date('2022-05-27 11:30:00','%Y-%m-%d %H:%i:%s'),'-05:00', '+05:30')as dtime;
   111  dtime
   112  2022-05-27 22:00:00