extract(milliseconds from time)

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.