var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Getting the Month Name from Numeric field showing as 20130918
How would I get the Month name of September from a Numeric(8,0) that displays the date as 20130918.
I have searched for sometime and tried many things and I'm not gettting anywhere. Any help would be appreciated.
One way might be
(1) Convert the numeric value to date(or timestamp) datatype(e.g. by using TO_DATE function).
(2) Then apply MONTHNAME function.
Yes, that did the trick, thanks very much for your advice tonkuma. :-)
Tags for this Thread