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")

  )