Apache Drill - Date Time AGE(x [, y ] )

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select age('2000-04-13') from (values(1));

Result

+-----------------+
|     EXPR$0      |
+-----------------+
| P195M4DT66600S  |
++

The output result is the interval limit from the specified year to midnight of the current day.