Number to Month conversion

dataservices job design
1

Hi All,

I was wondering if there was an easy way to convert the following string in the following way.

Input Ouput
1 → JAN
2 → FEB
3 → MAR
4 → APR
…

Now i’ve done it with ifthenelse, but i imagine there must be another way? :lol:

Kind regards
Laurens

lverstraeten :belgium: (BOB member since 2006-11-02)

2

Never mind i found it. :oops:

to_char(to_date(source.field,‘MM’),‘MON’)

i knew it was possible!

lverstraeten :belgium: (BOB member since 2006-11-02)