Spark: transform timestamp text to timestamp and extract some parts

spark_unix_timestamp.scala

val df =Seq((1L,"03JUN2015 19.28.00"),(2L,"#$@#@#")).toDF("id","dts")
import org.apache.spark.sql.functions.dayofmonth

import org.apache.spark.sql.functions.unix_timestamp

df.withColumn("ts", unix_timestamp($"dts","ddMMMyy HH.mm.ss").cast("timestamp"))
  .withColumn("dom", dayofmonth($"ts"))
  .withColumn("month", month($"ts"))
  .withColumn("yesar", year($"ts"))
  .show(2,false)

from pyspark.sql.functions import from_unixtime, unix_timestamp
from pyspark.sql.types import TimestampType

df.select((from_unixtime(unix_timestamp(
df.datetime, "yy-MMM-dd h.mm.ss.SSSSSS aa"
))).cast(TimestampType()).alias("datetime"))