create schema extract_units;
set current_schema = extract_units;
set dolphin.b_compatibility_mode=on;
select extract(epoch from timestamp'2019-07-02 12:12:12.12121');
select extract(year from timestamp'2019-07-02 12:12:12.12121');
select extract(quarter from timestamp'2019-07-02 12:12:12.12121');
select extract(month from timestamp'2019-07-02 12:12:12.12121');
select extract(week from timestamp'2019-07-02 12:12:12.12121');
select extract(day from timestamp'2019-07-02 12:12:12.12121');
select extract(hour from timestamp'2019-07-02 12:12:12.12121');
select extract(minute from timestamp'2019-07-02 12:12:12.12121');
select extract(second from timestamp'2019-07-02 12:12:12.12121');
select extract(microsecond from timestamp'2019-07-02 12:12:12.12121');
select extract(year_month from timestamp'2019-07-02 12:12:12.12121');
select extract(day_hour from timestamp'2019-07-02 12:12:12.12121');
select extract(day_minute from timestamp'2019-07-02 12:12:12.12121');
select extract(day_second from timestamp'2019-07-02 12:12:12.12121');
select extract(hour_minute from timestamp'2019-07-02 12:12:12.12121');
select extract(hour_second from timestamp'2019-07-02 12:12:12.12121');
select extract(minute_second from timestamp'2019-07-02 12:12:12.12121');
select extract(day_microsecond from timestamp'2019-07-02 12:12:12.12121');
select extract(hour_microsecond from timestamp'2019-07-02 12:12:12.12121');
select extract(minute_microsecond from timestamp'2019-07-02 12:12:12.12121');
select extract(second_microsecond from timestamp'2019-07-02 12:12:12.12121');

select extract(microsecond from date '2022-11-04');
select extract(minute from date '2022-11-04');
select extract(hour from date '2022-11-04');
select extract(second_microsecond from date '2022-11-04');
select extract(minute_microsecond from date '2022-11-04');
select extract(minute_second from date '2022-11-04');

reset current_schema;
drop schema extract_units;