Need to extract distict month name from a date column.
Found something like this
SELECT DISTINCT Format(appointmentdate,'mmmm') AS distinctmonth
but it does not work.
Please advise.