extract(microseconds from time)

Let us now check the extract(microseconds) function with the following query.

Query

default> select extract(microseconds from time '17:25:15') as seconds;  

Result

The above query will generate the following result.

seconds 
------------------------------- 
1.5E7 

The query extracts microseconds from the given time.