build a formatted string in oracle

Question

I need to build a string from some columns into another column, the trailing zeros must be removed from month and day :

YEAR=2008;MONTH=1;DAY=1;ID=1021; ... etc

For the day piece I've used the TO_CHAR(D_RIC,'D') function to remove leading zeros. Is there a format option for months to remove starting zeros too ?

Answer 1

"Fill Mode" (FM):

select to_char (datecol, 'FMMM') from mytable;