0

How to convert timestamp to Date in MV

HI,

 

I want to convert 9/22/20, 1:58:18 PM to 9/22/20 in MV. Please let me know how to do.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • In SQL:

    TO_DATE(CAST(unix_timestamp('2020-09-22 13:58:18') AS TIMESTAMP))

    In dataframe:

    df=df.withColumn("DATE_INEFFECTIVE", F.to_date(F.lit('9999-12-31'),'yyyy-MM-dd'))
    Like
Like Follow
  • 4 wk agoLast active
  • 1Replies
  • 12Views
  • 2 Following

Product Announcement


We are happy to
announce Incorta 4.8 !!!