| --! qt:dataset:src |
| drop table extract_udf_n0; |
| |
| create table extract_udf_n0 (t timestamp); |
| from (select * from src tablesample (1 rows)) s |
| insert overwrite table extract_udf_n0 |
| select '2011-05-06 07:08:09.1234567'; |
| |
| select t |
| from extract_udf_n0; |
| |
| explain |
| select floor_day(t) |
| from extract_udf_n0; |
| |
| select floor_day(t) |
| from extract_udf_n0; |
| |
| -- new syntax |
| explain |
| select floor(t to day) |
| from extract_udf_n0; |
| |
| select floor(t to day) |
| from extract_udf_n0; |
| |
| |
| select floor(t to second) |
| from extract_udf_n0; |
| |
| select floor(t to minute) |
| from extract_udf_n0; |
| |
| select floor(t to hour) |
| from extract_udf_n0; |
| |
| select floor(t to week) |
| from extract_udf_n0; |
| |
| select floor(t to month) |
| from extract_udf_n0; |
| |
| select floor(t to quarter) |
| from extract_udf_n0; |
| |
| select floor(t to year) |
| from extract_udf_n0; |