[Spark] from_unixtime & to_timestamp

spark.sql("select timestamp(from_unixtime(1563853753,'yyyy-MM-dd HH:mm:ss')) as ts").show(false)
+-------------------+
|ts                 |
+-------------------+
|2019-07-22 22:49:13|
+-------------------+

spark.sql("select to_timestamp(1563853753) as ts").show(false)
+-------------------+
|ts                 |
+-------------------+
|2019-07-22 22:49:13|
+-------------------+

https://stackoverflow.com/questions/57156200/spark-dataframe-convert-bigint-to-timestamp

Spark Dataframe: Convert bigint to timestamp

https://sparkbyexamples.com/spark/spark-convert-string-to-timestamp-format/

Spark to_timestamp() - Convert String to Timestamp type — Spark by {Examples}