convert month name

[hawley]

If you have a string that is equal to "June" how do you convert that to the month number, 06.

I have found stuff on getmonth and such but I don't have the whole date. Just the month name.

Thanks!!!

 

[Arthur1]

Easy way would be just to use a case statment:


string ls_month
integer i_month_num

Choose Case ls_month
CASE 'June'
i_month_num = 06
Case 'July'
i_month_num = 07
End CHOOSE

 

[pgaec]

Or...

string ls_month
integer li_month

ls_month = 'June'

select datepart(mm,'01 '+ls_month+' 2000')
into :li_month
using sqlca;