Convert date to 'yyyymmdd' format in MW

Nopu Nguyen
Human
Nopu_Nguyen
3 mths ago
2 replies
26
Nopu Nguyen3 mths ago
Questions & Answers
Answered

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.

views
sqli

Like Follow

- suxinji
- Sounthern Utah University
- suxinji
- 3 mths ago
- 2
- Questions & Answers
- Reported - view
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