Apache Drill - Date Time TIMEOFDAY()



The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select TIMEOFDAY() from (values(1));

Result

+---------------------------------------+
|                EXPR$1                 |
+---------------------------------------+
| 2016-04-24 15:19:24.243 Asia/Kolkata  |
+---------------------------------------+

Here, TIMEOFDAY() returns the result for UTC time zone.

apache_drill_sql_operations.htm
Advertisements