0

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
      • 3 mths ago
      • Reported - view

      suxinji Thank you so much, you saved my day.

      Like
Like Follow
  • Status Answered
  • 3 mths agoLast active
  • 2Replies
  • 26Views
  • 2 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!