Hi

Anyone know how do convert numerical months to text months in Oracle?

I'm looking for the Oracle equivelent of:

VB Code:
  1. Function ReturnTextMonth(ByVal iMonthNumber As Integer) As String
  2.  
  3. ReturnTextMonth = Format("01/" & iMonthNumber & "/2003", "mmm")
  4.  
  5. End Function