Google Git
Sign in
apache / drill-test-framework / d8d7538f560c515139a5f4743d86b15968a46092 / . / framework / resources / Functional / datetime / sql_to_timestamp_10.q
blob: 7d7669fecb98358cb3b831fd72a181646a3fc6a9 [file] [log] [blame]
select date_trunc('century',sql_to_timestamp('2017-03-31 10:13:00.44 am','yyyy-mm-dd HH12:MI:SS.MS am')),date_trunc('MILLENNIUM',sql_to_timestamp('2017-03-31 10:13:00.44 am','yyyy-mm-dd HH12:MI:SS.MS am')),date_trunc('week',sql_to_timestamp('2017-03-31 10:13:00.44 am','yyyy-mm-dd HH12:MI:SS.MS am')),date_trunc('hour',sql_to_timestamp('2017-03-31 10:13:00.44 am','yyyy-mm-dd HH12:MI:SS.MS am')),date_trunc('minute',sql_to_timestamp('2017-03-31 10:13:00.44 am','yyyy-mm-dd HH12:MI:SS.MS am')) from (values(1));