extract(milliseconds from time)
Advertisements
Let us now check the extract(milliseconds) function with the following query.
Query
default> select extract(milliseconds from time '17:25:15') as seconds;
Result
The above query will generate the following result.
seconds ------------------------------- 15000.0
The query extracts milliseconds from the specified time.
apache_tajo_datetime_functions.htm
Advertisements