Current_Data() in YYYYMM format in Datasphere View

[alexander_john_berlin]

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.

[Simon_Ye · Accepted solution]

Try this: TO_NVARCHAR(CURRENT_DATE,'YYYYMM')