Date extract conversion

[maxchuie]

Datasource: SQL Server
Forma:t Date   MMM D, YYYY
need to get MMM YYY

tried extract month gives me a number need text MMM

[bus_pass_man]

Extract will return an integer representing the month ordinal, which is what the the native sql server function does as well. 

Is there any reason why the sql server datename function isn't suitable for your purposes?

[cognostechie]

Datasource: SQL Server
Forma:t Date   MMM D, YYYY
need to get MMM YYY

tried extract month gives me a number need text MMM

There is a simple function which can convert the integer month to a character month and even name it like JAN, FEB but I will give you the solution when
you write the question properly instead of expecting people to understand what you are 'thinking'. Provide examples also about what the data looks like and what you want it to look like.