cancel
Showing results for 
Search instead for 
Did you mean: 

Current_Data() in YYYYMM format in Datasphere View

0 Kudos
126

I'm looking for the best way to format the current date into YYYYMM in a Datasphere View format so for today it should be 202406. To I have to format it as a string first and then recoverd it to date with TO_DATE()?

Thank you.

View Entire Topic
Simon_Ye
Product and Topic Expert
Product and Topic Expert
0 Kudos

Try this: TO_NVARCHAR(CURRENT_DATE,'YYYYMM')