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.
Hi, Nopu Nguyen .
I tried this. It seems working.
SELECT date_format(Current_Date, 'yyyyMMdd') from Audit.date
suxinji Thank you so much, you saved my day.
© Incorta, Inc. All Rights Reserved.
A new community experience is coming! If you would like to have beta access to provide feedback, please contact us at email@example.com.