Skip to main content
Last updated on

time_to_micros

Extracts microseconds from TIME value.

Syntax​

Python
from pyspark.databricks.sql import functions as dbf

dbf.time_to_micros(col=<col>)

Parameters​

Parameter

Type

Description

col

pyspark.sql.Column or column name

TIME value to convert.

Examples​

Python
from pyspark.databricks.sql import functions as dbf
df = spark.sql("SELECT TIME'14:30:00.5' as time")
df.select(dbf.time_to_micros('time')).show()
Output
+--------------------+
|time_to_micros(time)|
+--------------------+
|         52200500000|
+--------------------+