Reputation: 3
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?
Upvotes: 0
Views: 42