convert 2 number columns to a date

[ScanX]

Hello,
I have a table with 2 columns :
month_of_birth
year_of_birth

both are number datatype

I would like to have them converted into date datatype in the select (using a casting) and if possible into this format : "mmm yyyy"

Thanx in advance

Mika

 

[VDavid]

Try

select DATEFORMAT(string(year_of_birth
,'-01-',month_of_birth), 'Mmm yyyy') from TABLE

Hope this helps,

David.