How can i perform sort of a character return type as number?
I have a date column that I am formating using to_char function and only extracting month
select to_char(dd_date,'Month') from tab1;
Output >> Jan, feb, mar,,,,,
But sort start Alphabetically .. mean Feb comes before Jan. I need Months in calendar order...