Convert date to 'yyyymmdd' format in MW

Hi everyone!

I want to convert CURRENT_DATE to format 'yyyyMMdd' in materialized view,  I try CONVERT, and FORMAT function but it's not supported in SQL of MW, how I can do that ? thank you.

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi, Nopu Nguyen . 

    I tried this. It seems working. 

    SELECT date_format(Current_Date, 'yyyyMMdd') from Audit.date
    Like 2
      • Nopu Nguyen
      • Human
      • Nopu_Nguyen
      • 1 yr ago
      • Reported - view

      suxinji Thank you so much, you saved my day.

Like Follow
  • Status Answered
  • 1 yr agoLast active
  • 2Replies
  • 43Views
  • 2 Following

Product Announcement

A new community experience is coming! If you would like to have beta access to provide feedback, please contact us at community@incorta.com.