Databricks Community

BF · 01-28-2023

Hi all, I've a dataframe with CreateDate column with this format:CreateDate/Date(1593786688000+0200)//Date(1446032157000+0100)//Date(1533904635000+0200)//Date(1447839805000+0100)//Date(1589451249000+0200)/and I want to convert that format to date/tim...

BF · 01-29-2023

Thanks a lot @Ratna Chaitanya Raju Bandaru , I picked up your code and I did this:final_df = df.withColumn("CreateDateNew", concat(from_unixtime((F.regexp_extract(col("CreateDate"), "(\d+)", 1)/1000),"yyyy-MM-dd HH:mm:ss"), lit(" "), regexp_replace(...

Databricks Community

User Stats

User Activity

Pyspark - How do I convert date/timestamp of format like /Date(1593786688000+0200)/ in pyspark?

Re: Pyspark - How do I convert date/timestamp of format like /Date(1593786688000+0200)/ in pyspark?