faris abdallah
faris abdallah

Reputation: 3

Showing Months in Words in Oracle Fusion

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

Answers (0)

Related Questions