Date Time EXTRACT(x FROM y)

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select EXTRACT(SECOND FROM TIME '12:20:40') from(values(1));

Result

+————————-+
|  EXPR$0 |
+————————-+
|  40.0   |
+————————-+

The seconds extracted from the given time.