Time stamp changes in spark sql

User16826994223 — Thu, 17 Jun 2021 14:44:57 GMT

Hi Team

Is there a way to change the current timestamp from the current time zone to a different time zone .

Re: Time stamp changes in spark sql

Srikanth_Gupta_ — Thu, 17 Jun 2021 15:57:17 GMT

import sqlContext.implicits._

import org.apache.spark.sql.functions._

inputDF.select(

unix_timestamp($"unix_timestamp").alias("unix_timestamp"),

from_utc_timestamp($"unix_timestamp".cast(DataTypes.TimestampType), "UTC").alias("UTC"),

from_utc_timestamp($"unix_timestamp".cast(DataTypes.TimestampType), "America/Los_Angeles").alias("pst_timestamp")

)