Apache Drill Date Function | Notes |
CLOCK_TIMESTAMP | |
COALESCE | |
CURRENT_DATE | |
CURRENT_TIME | |
CURRENT_TIMESTAMP | |
DATE_ADD | |
DATE_SUB | |
DATE_PART | |
DAY | |
DAYNAME | |
DAYS | |
DAYS_BETWEEN | |
DB_TIMEZONE | |
EXTRACT_DAY | |
EXTRACT_MONTH | |
EXTRACT_YEAR | |
EXTRACT_HOUR | |
EXTRACT_MINUTE | |
EXTRACT_SECOND | |
FROM_UNIXTIME | |
GETUTCDATE | |
MONTH | |
MONTHNAME | |
MONTHS_BETWEEN | |
NOW | |
TIME_SLICE | |
TRUNC | |
TZ_OFFSET | |
TZ_CONVERTOR | |
UNIX_TIMESTAMP | |
UTC_TO_TIMESTAMP | |
YEAR |