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
Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements