I'm Trying to Display Months in Words in Oracle Fusion as a List of Values but it doesn't work.
code
SELECT distinct to_char(start_date,'Month')
from per_all_people_f papf
ORDER BY to_char(start_date,'Month')
results
01
02
03
... etc
I Also Tried to_char(start_date,'Mon') to show Jan, Feb .. etc, but nothing works, only numbers are returned, what's the issue here?