create schema test_interval_expr;
set current_schema to 'test_interval_expr';

set dolphin.support_interval_to to off;
select '1 2'::interval year to month;
select '1 2'::interval day to hour;
select '1 2 3'::interval day to minute;
select '1 2 3 4'::interval day to second;
select '1 2 3 4 5'::interval day to microsecond;
select '1 2'::interval hour to minute;
select '1 2 3'::interval hour to second;
select '1 2 3 4'::interval hour to microsecond;
select '1 2'::interval minute to second;
select '1 2 3'::interval minute to microsecond;
select '1 2'::interval second to microsecond;
select interval '1 2' year to month;
select interval '1 2' day to hour;
select interval '1 2 3' day to minute;
select interval '1 2 3 4' day to second;
select interval '1 2 3 4 5' day to microsecond;
select interval '1 2' hour to minute;
select interval '1 2 3' hour to second;
select interval '1 2 3 4' hour to microsecond;
select interval '1 2' minute to second;
select interval '1 2 3' minute to microsecond;
select interval '1 2' second to microsecond;

set dolphin.support_interval_to to on;

-- 类型
select 1::interval;
select 1::interval year;
select 1::interval quarter;
select 1::interval month;
select 1::interval week;
select 1::interval day;
select 1::interval hour;
select 1::interval minute;
select 1::interval second;
select 1::interval microsecond;
select '1 2'::interval year_month;
select '1 2'::interval year to month;
select '1 2'::interval day_hour;
select '1 2'::interval day to hour;
select '1 2 3'::interval day_minute;
select '1 2 3'::interval day to minute;
select '1 2 3 4'::interval day_second;
select '1 2 3 4'::interval day to second;
select '1 2 3 4 5'::interval day_microsecond;
select '1 2 3 4 5'::interval day to microsecond;
select '1 2'::interval hour_minute;
select '1 2'::interval hour to minute;
select '1 2 3'::interval hour_second;
select '1 2 3'::interval hour to second;
select '1 2 3 4'::interval hour_microsecond;
select '1 2 3 4'::interval hour to microsecond;
select '1 2'::interval minute_second;
select '1 2'::interval minute to second;
select '1 2 3'::interval minute_microsecond;
select '1 2 3'::interval minute to microsecond;
select '1 2'::interval second_microsecond;
select '1 2'::interval second to microsecond;

-- 表达式
select interval 1 + 2 * 3 + 0.1 year;
select interval 1 + 2 * 3 + 0.1 quarter;
select interval 1 + 2 * 3 + 0.1 month;
select interval 1 + 2 * 3 + 0.1 week;
select interval 1 + 2 * 3 + 0.1 day;
select interval 1 + 2 * 3 + 0.1 hour;
select interval 1 + 2 * 3 + 0.1 minute;
select interval 1 + 2 * 3 + 0.1 second;
select interval 1 + 2 * 3 + 0.1 microsecond;
select interval '1 2' year_month;
select interval '1 2' year to month;
select interval '1 2' day_hour;
select interval '1 2' day to hour;
select interval '1 2 3' day_minute;
select interval '1 2 3' day to minute;
select interval '1 2 3 4' day_second;
select interval '1 2 3 4' day to second;
select interval '1 2 3 4 5' day_microsecond;
select interval '1 2 3 4 5' day to microsecond;
select interval '1 2' hour_minute;
select interval '1 2' hour to minute;
select interval '1 2 3' hour_second;
select interval '1 2 3' hour to second;
select interval '1 2 3 4' hour_microsecond;
select interval '1 2 3 4' hour to microsecond;
select interval '1 2' minute_second;
select interval '1 2' minute to second;
select interval '1 2 3' minute_microsecond;
select interval '1 2 3' minute to microsecond;
select interval '1 2' second_microsecond;
select interval '1 2' second to microsecond;
select interval 1 year year;
select interval 1 month month;
select interval 1 day day;
select interval 1 hour hour;
select interval 1 minute minute;
select interval 1 second second;
select date'20020304' + interval 1 hour;
select interval 1 hour + date'20020304';
select date'20020304' - interval 1 hour;
select date'20020304' + interval 1 minute;
select interval 1 minute + date'20020304';
select date'20020304' - interval 1 minute;
select date'20020304' + interval 1 second;
select interval 1 second + date'20020304';
select date'20020304' - interval 1 second;
select date'20020304' * interval 1 hour;
select date'20020304' / interval 1 hour;
select date'20020304' * interval 1 minute;
select date'20020304' / interval 1 minute;
select date'20020304' * interval 1 second;
select date'20020304' / interval 1 second;

create table k_1(a json,b blob,c longblob,d mediumblob,e tinyblob,f binary(20));
insert k_1 values('"2024-01-11 11:49:25"','2024-01-11 11:49:25','2024-01-11 11:49:25','2024-01-11 11:49:25','2024-01-11 11:49:25','2024-01-11 11:49:25');
select `a`+  interval 1 day,`b`+  interval 1 day,`c`+ interval 1 day,`d`+ interval 1 day,`e`+ interval 1 day,`f`+ interval 1 day from k_1;
drop table k_1;
select cast('1.23' as json) + (interval 1 day);
select cast('1.23' as blob) + (interval 1 day);
select cast('1.23' as longblob) + (interval 1 day);
select cast('1.23' as mediumblob) + (interval 1 day);
select cast('1.23' as tinyblob) + (interval 1 day);

-- 绑定参数
prepare stmt as 'select ? + interval 1 + ? year';
execute stmt('2024-06-18 18:30:00', 1);
prepare stmt as 'select ? + interval 1 + ? quarter';
execute stmt('2024-06-18 18:30:00', 1);
prepare stmt as 'select ? + interval 1 + ? month';
execute stmt('2024-06-18 18:30:00', 1);
prepare stmt as 'select ? + interval 1 + ? week';
execute stmt('2024-06-18 18:30:00', 1);
prepare stmt as 'select ? + interval 1 + ? day';
execute stmt('2024-06-18 18:30:00', 1);
prepare stmt as 'select ? + interval 1 + ? hour';
execute stmt('2024-06-18 18:30:00', 1);
prepare stmt as 'select ? + interval 1 + ? minute';
execute stmt('2024-06-18 18:30:00', 1);
prepare stmt as 'select ? + interval 1 + ? second';
execute stmt('2024-06-18 18:30:00', 1);
prepare stmt as 'select ? + interval 1 + ? microsecond';
execute stmt('2024-06-18 18:30:00', 1);
prepare stmt as 'select ? + interval ? year_month';
execute stmt('2024-06-18 18:30:00', '1 2');
prepare stmt as 'select ? + interval ? year to month';
execute stmt('2024-06-18 18:30:00', '1 2');
prepare stmt as 'select ? + interval ? day_hour';
execute stmt('2024-06-18 18:30:00', '1 2');
prepare stmt as 'select ? + interval ? day to hour';
execute stmt('2024-06-18 18:30:00', '1 2');
prepare stmt as 'select ? + interval ? day_minute';
execute stmt('2024-06-18 18:30:00', '1 2');
prepare stmt as 'select ? + interval ? day to minute';
execute stmt('2024-06-18 18:30:00', '1 2 3');
prepare stmt as 'select ? + interval ? day_second';
execute stmt('2024-06-18 18:30:00', '1 2 3');
prepare stmt as 'select ? + interval ? day to second';
execute stmt('2024-06-18 18:30:00', '1 2 3 4');
prepare stmt as 'select ? + interval ? day_microsecond';
execute stmt('2024-06-18 18:30:00', '1 2 3 4 5');
prepare stmt as 'select ? + interval ? day to microsecond';
execute stmt('2024-06-18 18:30:00', '1 2 3 4 5');
prepare stmt as 'select ? + interval ? hour_minute';
execute stmt('2024-06-18 18:30:00', '1 2');
prepare stmt as 'select ? + interval ? hour to minute';
execute stmt('2024-06-18 18:30:00', '1 2');
prepare stmt as 'select ? + interval ? hour_second';
execute stmt('2024-06-18 18:30:00', '1 2 3');
prepare stmt as 'select ? + interval ? hour to second';
execute stmt('2024-06-18 18:30:00', '1 2 3');
prepare stmt as 'select ? + interval ? hour_microsecond';
execute stmt('2024-06-18 18:30:00', '1 2 3 4');
prepare stmt as 'select ? + interval ? hour to microsecond';
execute stmt('2024-06-18 18:30:00', '1 2 3 4');
prepare stmt as 'select ? + interval ? minute_second';
execute stmt('2024-06-18 18:30:00', '1 2');
prepare stmt as 'select ? + interval ? minute to second';
execute stmt('2024-06-18 18:30:00', '1 2');
prepare stmt as 'select ? + interval ? minute_microsecond';
execute stmt('2024-06-18 18:30:00', '1 2 3');
prepare stmt as 'select ? + interval ? minute to microsecond';
execute stmt('2024-06-18 18:30:00', '1 2 3');
prepare stmt as 'select ? + interval ? second_microsecond';
execute stmt('2024-06-18 18:30:00', '1 2');
prepare stmt as 'select ? + interval ? second to microsecond';
execute stmt('2024-06-18 18:30:00', '1 2');

-- 列引用
create table t1 (c1 int);
insert into t1 values(1);
select '2024-06-18 18:30:00' + interval 1 + c1 year from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 quarter from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 month from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 week from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 day from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 hour from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 minute from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 second from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 microsecond from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 year_month from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 year to month from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 day_hour from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 day to hour from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 day_minute from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 day to minute from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 day_second from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 day to second from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 day_microsecond from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 day to microsecond from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 hour_minute from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 hour to minute from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 hour_second from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 hour to second from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 hour_microsecond from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 hour to microsecond from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 minute_second from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 minute to second from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 minute_microsecond from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 minute to microsecond from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 second_microsecond from t1;
select '2024-06-18 18:30:00' + interval 1 + c1 second to microsecond from t1;

select '2024-06-18 18:30:00' - interval 1 + c1 year from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 quarter from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 month from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 week from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 day from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 hour from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 minute from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 second from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 microsecond from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 year_month from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 year to month from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 day_hour from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 day to hour from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 day_minute from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 day to minute from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 day_second from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 day to second from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 day_microsecond from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 day to microsecond from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 hour_minute from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 hour to minute from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 hour_second from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 hour to second from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 hour_microsecond from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 hour to microsecond from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 minute_second from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 minute to second from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 minute_microsecond from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 minute to microsecond from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 second_microsecond from t1;
select '2024-06-18 18:30:00' - interval 1 + c1 second to microsecond from t1;

-- 函数
set dolphin.cmpt_version=8.0;
select date_add(time'38:59:58', interval '5 4' year_month);
select date_add(time'38:59:58', interval '5 4' day_minute);
select date_add(time'38:59:58', interval '5:4' day_second);
select date_add(time'38:59:58', interval '5:4' day_hour);
select date_add(time'38:59:58', interval '5:4' hour_minute);
select date_add(time'38:59:58', interval '5 4' hour_second);
select date_add(time'38:59:58', interval '5 4' minute_second);
select date_add(time'38:59:58', interval '5 4' week);
select date_sub(time'38:59:58', interval '5 4' year_month);
select date_sub(time'38:59:58', interval '5 4' day_minute);
select date_sub(time'38:59:58', interval '5:4' day_second);
select date_sub(time'38:59:58', interval '5:4' day_hour);
select date_sub(time'38:59:58', interval '5:4' hour_minute);
select date_sub(time'38:59:58', interval '5 4' hour_second);
select date_sub(time'38:59:58', interval '5 4' minute_second);
select date_sub(time'38:59:58', interval '5 4' week);
set dolphin.cmpt_version=5.7;

select date_add('2022-06-10 15:15:15', -10::interval year ) as updated_date;
select date_sub('2022-06-10 15:15:15', -10::interval year ) as updated_date;
select date_add('2022-06-10 15:15:15', -10::interval hour ) as updated_date;
select date_sub('2022-06-10 15:15:15', -10::interval hour ) as updated_date;
select date_add('2022-06-10 15:15:15', 10::interval year ) as updated_date;
select date_sub('2022-06-10 15:15:15', 10::interval year ) as updated_date;
select date_add('2022-06-10 15:15:15', 10::interval hour ) as updated_date;
select date_sub('2022-06-10 15:15:15', 10::interval hour ) as updated_date;
-- 运算
select '2024-07-05 14:25:59' + interval 1 minute + 1;
select '2024-07-05' + interval 1 minute + 1;
select '2024-07-05 14:25:59' + interval 1 year + 1;
select '2024-07-05' + interval 1 year + 1;
select '2024-07-05 14:25:59' + interval 1 day + 1;
select '2024-07-05' + interval 1 day + 1;
select '2024-07-05 14:25:59' + interval 1 year_month + 1;
select '2024-07-05' + interval 1 year_month + 1;
select '2024-07-05 14:25:59' + interval 1 day_hour + 1;
select '2024-07-05' + interval 1 day_hour + 1;
select interval 1 minute + '2024-07-05 14:25:59' + 1;
select interval 1 minute + '2024-07-05' + 1;
select interval 1 year +'2024-07-05 14:25:59' + 1;
select interval 1 year + '2024-07-05' + 1;
select interval 1 day + '2024-07-05 14:25:59' + 1;
select interval 1 day + '2024-07-05' + 1;
select interval 1 year_month + '2024-07-05 14:25:59' + 1;
select interval 1 year_month + '2024-07-05' + interval 1 year_month + 1;
select interval 1 day_hour + '2024-07-05 14:25:59' + 1;
select interval 1 day_hour + '2024-07-05' + 1;
select '2024-07-05 14:25:59' - interval 1 minute + 1;
select '2024-07-05' - interval 1 minute + 1;
select '2024-07-05 14:25:59' - interval 1 year + 1;
select '2024-07-05' - interval 1 year + 1;
select '2024-07-05 14:25:59' - interval 1 day + 1;
select '2024-07-05' - interval 1 day + 1;
select '2024-07-05 14:25:59' - interval 1 year_month + 1;
select '2024-07-05' - interval 1 year_month + 1;
select '2024-07-05 14:25:59' - interval 1 day_hour + 1;
select '2024-07-05' - interval 1 day_hour + 1;

select '20230205231050.968789' + interval 1 minute;
select '20230205231050.968789' + interval 1 hour;
select '20230205231050.968789' + interval 1 year;
select '20230205231050.968789' + interval 1 day;
select '20230205231050.968789' + interval 1 year_month;
select '20230205231050.968789' + interval 1 day_hour;
select '20230205231050.968789' + interval 1 day_microsecond;
select interval 1 minute + '20230205231050.968789';
select interval 1 hour + '20230205231050.968789';
select interval 1 year + '20230205231050.968789';
select interval 1 day + '20230205231050.968789';
select interval 1 year_month + '20230205231050.968789';
select interval 1 day_hour + '20230205231050.968789';
select interval 1 day_microsecond + '20230205231050.968789';
select '20230205231050.968789' - interval 1 minute;
select '20230205231050.968789' - interval 1 hour;
select '20230205231050.968789' - interval 1 year;
select '20230205231050.968789' - interval 1 day;
select '20230205231050.968789' - interval 1 year_month;
select '20230205231050.968789' - interval 1 day_hour;
select '20230205231050.968789' - interval 1 day_microsecond;

select '2023-02-28 14:25:59.999999' + interval 1 day_microsecond;
select '2023-02-28 14:25:59.999999' + interval 1 year;
select '2023-02-28 14:25:59.999999' + interval 1 month;
select '2023-02-28 14:25:59.999999' + interval 1 day;
select '2023-02-28 14:25:59.999999' + interval 1 hour;
select '2023-02-28 14:25:59.999999' + interval 1 minute;
select '2023-02-28 14:25:59.999999' + interval 1 second;
select interval 1 day_microsecond + '2023-02-28 14:25:59.999999';
select interval 1 year + '2023-02-28 14:25:59.999999';
select interval 1 month + '2023-02-28 14:25:59.999999';
select interval 1 day + '2023-02-28 14:25:59.999999';
select interval 1 hour + '2023-02-28 14:25:59.999999';
select interval 1 minute + '2023-02-28 14:25:59.999999';
select interval 1 second + '2023-02-28 14:25:59.999999';
select '2023-02-28 14:25:59.999999' - interval 1 day_microsecond;
select '2023-02-28 14:25:59.999999' - interval 1 year;
select '2023-02-28 14:25:59.999999' - interval 1 month;
select '2023-02-28 14:25:59.999999' - interval 1 day;
select '2023-02-28 14:25:59.999999' - interval 1 hour;
select '2023-02-28 14:25:59.999999' - interval 1 minute;
select '2023-02-28 14:25:59.999999' - interval 1 second;

select date '20010928' + interval '1 hour' as result;
select date '20010928' + interval '1 day' as result;
select date '20010928' + interval '1 day 1 hour' as result;
select interval '1 hour' + date '20010928' as result;
select interval '1 day' + date '20010928' as result;
select interval '1 day 1 hour' + date '20010928' as result;
select date '2001-09-28' - interval '1 hour' as result;
select date '2001-09-28' - interval '1 day' as result;
select date '2001-09-28' - interval '1 day 1 hour' as result;

-- 全类型兼容
create table all_types_table (
    `int1` tinyint,
    `uint1` tinyint unsigned,
    `int2` smallint,
    `uint2` smallint unsigned,
    `int4` integer,
    `uint4` integer unsigned,
    `int8` bigint,
    `uint8` bigint unsigned,
    `float4` float4,
    `float8` float8,
    `numeric` decimal(20, 6),
    `bit1` bit(1),
    `bit64` bit(64),
    `boolean` boolean,
    `date` date,
    `time` time,
    `time4` time(4),
    `datetime` datetime,
    `datetime4` datetime(4) default '2023-12-30 12:00:12',
    `timestamp` timestamp,
    `timestamp4` timestamp(4) default '2023-12-30 12:00:12',
    `year` year,
    `char` char(100),
    `varchar` varchar(100),
    `binary` binary(100),
    `varbinary` varbinary(100),
    `tinyblob` tinyblob,
    `blob` blob,
    `mediumblob` mediumblob,
    `longblob` longblob,
    `text` text,
    `enum_t` enum('a', 'b', 'c'),
    `set_t` set('a', 'b', 'c'),
    `json` json,
    `null` integer
);
INSERT INTO all_types_table
VALUES(
        1,
        1,
        1,
        1,
        1,
        1,
        1,
        1,
        1.0,
        1.0,
        3.14259,
        1,
        10101100,
        1,
        '2024-01-11',
        '11:47:58',
        '11:47:58.7896',
        '2024-01-11 11:49:25',
        '2024-01-11 11:49:25.1234',
        '2024-01-11 11:49:25',
        '2024-01-11 11:49:25.1234',
        '2024',
        '62.345*67-89',
        '62.345*67-89',
        '67890 - 12345 = 55545',
        '67890 - 12345 = 55545',
        '67890 - 12345 = 55545',
        '67890 - 12345 = 55545',
        '67890 - 12345 = 55545',
        '67890 - 12345 = 55545',
        '67890 - 12345 = 55545',
        'b',
        'a,b',
        json_object('a', 2, 'b', 3),
        NULL
    );

select '2024-06-18 18:30:00' - interval `int1` year from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` month from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` week from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` day from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` second from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int1` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` year from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` month from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` week from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` day from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint1` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` year from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` month from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` week from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` day from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` second from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int2` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` year from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` month from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` week from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` day from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint2` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` year from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` month from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` week from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` day from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` second from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int4` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` year from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` month from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` week from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` day from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint4` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` year from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` month from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` week from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` day from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` second from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `int8` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` year from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` month from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` week from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` day from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `uint8` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` year from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` month from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` week from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` day from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` second from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float4` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` year from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` month from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` week from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` day from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` second from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `float8` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` year from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` month from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` week from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` day from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` second from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `numeric` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` year from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` month from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` week from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` day from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` second from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit1` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` year from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` month from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` week from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` day from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` second from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `bit64` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` year from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` month from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` week from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` day from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` second from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `boolean` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `date` year from all_types_table;
select '2024-06-18 18:30:00' - interval `date` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `date` month from all_types_table;
select '2024-06-18 18:30:00' - interval `date` week from all_types_table;
select '2024-06-18 18:30:00' - interval `date` day from all_types_table;
select '2024-06-18 18:30:00' - interval `date` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `date` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `date` second from all_types_table;
select '2024-06-18 18:30:00' - interval `date` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `date` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `date` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `date` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `date` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `date` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `date` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `date` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `date` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `date` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `date` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `date` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `date` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `date` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `date` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `date` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `date` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `date` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `date` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `date` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `date` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `date` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `date` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time` year from all_types_table;
select '2024-06-18 18:30:00' - interval `time` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `time` month from all_types_table;
select '2024-06-18 18:30:00' - interval `time` week from all_types_table;
select '2024-06-18 18:30:00' - interval `time` day from all_types_table;
select '2024-06-18 18:30:00' - interval `time` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `time` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `time` second from all_types_table;
select '2024-06-18 18:30:00' - interval `time` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `time` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `time` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `time` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `time` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `time` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `time` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `time` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `time` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `time` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `time` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `time` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `time` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `time` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `time` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` year from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` month from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` week from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` day from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` second from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `time4` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` year from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` month from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` week from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` day from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` second from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` year from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` month from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` week from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` day from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` second from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `datetime4` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` year from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` month from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` week from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` day from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` second from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` year from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` month from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` week from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` day from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` second from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `timestamp4` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `year` year from all_types_table;
select '2024-06-18 18:30:00' - interval `year` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `year` month from all_types_table;
select '2024-06-18 18:30:00' - interval `year` week from all_types_table;
select '2024-06-18 18:30:00' - interval `year` day from all_types_table;
select '2024-06-18 18:30:00' - interval `year` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `year` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `year` second from all_types_table;
select '2024-06-18 18:30:00' - interval `year` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `year` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `year` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `year` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `year` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `year` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `year` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `year` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `year` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `year` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `year` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `year` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `year` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `year` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `year` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `year` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `year` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `year` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `year` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `year` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `year` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `year` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `year` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `char` year from all_types_table;
select '2024-06-18 18:30:00' - interval `char` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `char` month from all_types_table;
select '2024-06-18 18:30:00' - interval `char` week from all_types_table;
select '2024-06-18 18:30:00' - interval `char` day from all_types_table;
select '2024-06-18 18:30:00' - interval `char` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `char` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `char` second from all_types_table;
select '2024-06-18 18:30:00' - interval `char` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `char` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `char` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `char` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `char` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `char` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `char` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `char` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `char` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `char` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `char` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `char` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `char` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `char` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `char` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `char` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `char` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `char` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `char` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `char` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `char` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `char` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `char` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` year from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` month from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` week from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` day from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` second from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varchar` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` year from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` month from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` week from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` day from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` second from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `binary` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` year from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` month from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` week from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` day from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` second from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `varbinary` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` year from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` month from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` week from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` day from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` second from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `tinyblob` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` year from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` month from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` week from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` day from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` second from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `blob` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` year from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` month from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` week from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` day from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` second from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `mediumblob` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` year from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` month from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` week from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` day from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` second from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `longblob` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `text` year from all_types_table;
select '2024-06-18 18:30:00' - interval `text` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `text` month from all_types_table;
select '2024-06-18 18:30:00' - interval `text` week from all_types_table;
select '2024-06-18 18:30:00' - interval `text` day from all_types_table;
select '2024-06-18 18:30:00' - interval `text` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `text` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `text` second from all_types_table;
select '2024-06-18 18:30:00' - interval `text` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `text` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `text` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `text` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `text` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `text` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `text` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `text` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `text` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `text` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `text` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `text` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `text` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `text` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `text` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `text` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `text` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `text` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `text` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `text` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `text` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `text` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `text` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` year from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` month from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` week from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` day from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` second from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `enum_t` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` year from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` month from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` week from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` day from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` second from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `set_t` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `json` year from all_types_table;
select '2024-06-18 18:30:00' - interval `json` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `json` month from all_types_table;
select '2024-06-18 18:30:00' - interval `json` week from all_types_table;
select '2024-06-18 18:30:00' - interval `json` day from all_types_table;
select '2024-06-18 18:30:00' - interval `json` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `json` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `json` second from all_types_table;
select '2024-06-18 18:30:00' - interval `json` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `json` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `json` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `json` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `json` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `json` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `json` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `json` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `json` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `json` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `json` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `json` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `json` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `json` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `json` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `json` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `json` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `json` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `json` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `json` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `json` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `json` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `json` second to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` year from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` quarter from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` month from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` week from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` day from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` hour from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` minute from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` second from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` year_month from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` year to month from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` day_hour from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` day to hour from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` day_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` day to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` day_second from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` day to second from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` day_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` day to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` hour_minute from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` hour to minute from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` hour_second from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` hour to second from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` hour_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` hour to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` minute_second from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` minute to second from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` minute_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` minute to microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` second_microsecond from all_types_table;
select '2024-06-18 18:30:00' - interval `NULL` second to microsecond from all_types_table;

set time zone '+8';
create table t2(ts1 timestamp, ts2 interval);
insert t2 values('1902-11-20 14:14:16.9999999', interval 2 minute);
insert t2 values('09-09-14 23:59:59.9999999', interval 3 second);
select ts1 - ts2 from t2;
select ts1 + ts2 from t2;
select ts1 - ts2 from t2;

create table t3(c1 datetime);
insert t3 values('2024-07-05'), ('2024-07-05 14:59:58');
create view v1 as select c1 + interval 1 day as 'c1 + interval 1 day' from t3;
select * from v1;
create view v2 as select c1 - interval 1 day as 'c1 - interval 1 day' from t3;
select * from v2;

select datetime'2024-06-11 14:29:25'+ interval datetime'2024-02-11 14:29:25' minute;
select timestamp'2024-06-11 14:29:25'+ interval timestamp'2024-02-11 14:29:25' minute;
select timestamp'9990-06-11 14:29:25' + interval 9 year;
select timestamp'9990-06-11 14:29:25' + interval 99 year;

select '2003-11-11 00:00:50'::blob + interval '2' second;
select interval '2' second + '2003-11-11 00:00:50'::blob;
select '2003-11-11 00:00:50'::longblob + interval '2' second;
select interval '2' second + '2003-11-11 00:00:50'::longblob;
select '2003-11-11 00:00:50'::mediumblob + interval '2' second;
select interval '2' second + '2003-11-11 00:00:50'::mediumblob;
select '2003-11-11 00:00:50'::tinyblob + interval '2' second;
select interval '2' second + '2003-11-11 00:00:50'::tinyblob;
select '20031111000050'::json + interval '2' second;
select interval '2' second + '20031111000050'::json;

-- test desc/explain for `interval day(precision) to second(precision)` and `year(precision) to month`
set dolphin.support_interval_to = on;
create table t_explain_001(c_time_interval interval day(3) to second (4));
desc t_explain_001;
explain t_explain_001;
create table t_explain_002(c_time_interval interval day to second (4));
desc t_explain_002;
explain t_explain_002;
create table t_explain_003(c_time_interval interval day(3) to second);
desc t_explain_003;
explain t_explain_003;
create table t_explain_004(c_time_interval interval day to second);
desc t_explain_004;
explain t_explain_004;
create table t_explain_005(c_time_interval interval year(3) to month);
desc t_explain_005;
explain t_explain_005;
create table t_explain_006(c_time_interval interval year to month);
desc t_explain_006;
explain t_explain_006;
--- expect error
create table t_explain_007(c_time_interval interval year(10) to month);
drop table t_explain_001,t_explain_002,t_explain_003,t_explain_004,t_explain_005,t_explain_006;
reset dolphin.support_interval_to;

drop table all_types_table cascade;
drop schema test_interval_expr cascade;
reset current_schema;