How to convert date to 'yyyymmdd' format in MV

 I got this question from community.incorta.com. 

Question: 

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

Answer:


Comments

Post a Comment

Popular posts from this blog

Using Time Series Analysis Electric Production by FB Prophet

Image
I got the dataset from Kaggle for practicing time series analysis.  https://www.kaggle.com/kandij/electric-production    The data set used here has 2 columns, one column is the date and the other column relates to the consumption percentage. It includes the data from Dec 31,1984 to Dec 31,2017. For predicting the consumption of electricity in the coming future.  I used time series analysis in Incorta notebooks using Facebook Prophet.  Here is the result in Incorta. The blue line showing original data, and the green line showing predict electric production. 
Read more

Using Time Series Analysis Electric Production by ARIMA Model

Image
I got the dataset from Kaggle for practicing time series analysis.  https://www.kaggle.com/kandij/electric-production    The data set used here has 2 columns, one column is the date and the other column relates to the consumption percentage. It includes the data from Dec 31,1984 to Dec 31,2017. For predicting the consumption of electricity in the coming future.  I loaded data into Incorta, and use the Incorta API to read the data from Jupyter notebook. I save the model in the external notebook and use data in Incorta.  First, I import data to Incorta. Then I use the Incorta API to read the data in Jupyter notebooks. Then, I use the model in Incorta.  Here is the result in Incorta. The blue line showing original data, and the green line showing predict electric production. 
Read more