Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am trying to get a Month-Year field from SCHEDULEDDTM, see below. An example of the format for SCHEDULEDDTTM is 2022-01-01 00:00:00.000000
I am only able to get the first row to display correctly:
My code to get this is:
date(monthstart(SCHEDULEDDTTM), 'MMM-YYYY') as SCHEDULED_YEAR_MONTH
How do I achieve this? Please help, thank you!
It looks quite ok to me, i would expect it to work.
Try beeing more explicit, maybe do this adjustment.
Monthname(timestamp#(SCHEDULEDDTTM,'YYYY-MM-DD hh:mm:ss.fff') as SCHEDULED_YEAR_MONTH
It looks quite ok to me, i would expect it to work.
Try beeing more explicit, maybe do this adjustment.
Monthname(timestamp#(SCHEDULEDDTTM,'YYYY-MM-DD hh:mm:ss.fff') as SCHEDULED_YEAR_MONTH