from_unixtime
Converts the number of seconds from unix epoch (1970-01-01 00:00:00 UTC) to a string representing the timestamp of that moment in the current system time zone in the given format.
For the corresponding Databricks SQL function, see from_unixtime function.
Syntax
Python
from pyspark.databricks.sql import functions as dbf
dbf.from_unixtime(timestamp=<timestamp>, format=<format>)
Parameters
Parameter | Type | Description |
|---|---|---|
|
| column of unix time values. |
|
| format to use to convert to (default: yyyy-MM-dd HH:mm:ss) |
Returns
pyspark.sql.Column: formatted timestamp as string.
Examples
Python
spark.conf.set("spark.sql.session.timeZone", "America/Los_Angeles")
Python
from pyspark.databricks.sql import functions as dbf
df = spark.createDataFrame([(1428476400,)], ['unix_time'])
df.select('*', dbf.from_unixtime('unix_time')).show()
spark.conf.unset("spark.sql.session.timeZone")