Date Formats in Oracle

Hi

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

I'm looking for the Oracle equivelent of:

VB Code:

Function ReturnTextMonth(ByVal iMonthNumber As Integer) As String
 
ReturnTextMonth = Format("01/" & iMonthNumber & "/2003", "mmm")
 
End Function

Similar to your vb code, you could convert it to a valid date, then convert it back to a charater string for your three digit month abbreviation. Try

<code>
select to_char(to_date('01/' || '02' || '/2003', 'DD/MM/YYYY'), 'MON') from dual
</code>

Should give you "FEB" as a result.