Google Git
Sign in
apache / drill-test-framework / b5ed55188c294aa172ccc7d30e7981884fedc8f0 / . / framework / resources / Functional / datetime / sql_to_timestamp_7.q
blob: b6d01dd34dd177037a98e9ea14a1c55e411b8382 [file] [log] [blame]
select c_row,date_part('year',sql_to_timestamp(c_timestamp,'YYYY-mm-dd HH24:MI:SS')),date_part('month',sql_to_timestamp(c_timestamp,'YYYY-mm-dd HH24:MI:SS')),date_part('day',sql_to_timestamp(c_timestamp,'YYYY-mm-dd HH24:MI:SS')),date_part('hour',sql_to_timestamp(c_timestamp,'YYYY-mm-dd HH24:MI:SS')),date_part('minute',sql_to_timestamp(c_timestamp,'YYYY-mm-dd HH24:MI:SS')),date_part('second',sql_to_timestamp(c_timestamp,'YYYY-mm-dd HH24:MI:SS')) from basic where c_row=1;