I am trying to find a way to get a conversion of the DATEPART function for Month so that it’s spelled out instead of just a number. With SQL there is the DATENAME function that should work just the same as DATEPART except it can return a character string instead of an integer. Unfortunately I can’t seem to get DATENAME to work, and it’s not in the OQL documentation as something I can use. I also tried to use the FORMAT function to try and achieve this result, but didn’t have any luck there either. Anyone know of a way to do this with OQL, or is this not an option currently?
How did you try to query using DATENAME? Though it’s not documented, I recall having used it in the past as follows:
SELECT DATENAME("month", DateRegistered) AS RegistrationMonth