2 Replies Latest reply: Feb 5, 2013 1:58 AM by sivaraj seeman RSS

    Showing month in list box

      Hi

       

      I am extracting the month name from a column using the substr(to_char(MY_DATE), 4, 3)  as MONTH. I am able to do it successfully. Now I am getting a problem where my listbox doesnt show the month in the order of Jan-Dec.

       

      I have attached the listbox image.

       

      Any suggestions ??