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.
Incorta 4.9 is now Generally Available (GA)!!!