Convert DateTime to 3-char month

[dolodolo]

Hi,

I am looking for the code to convert a date field to a 3-character month - e.g. JUL. Here's what I have but it's just returning the number.

select convert(varchar, (datepart(mm, dtdate))) from cmrevision

Any help is most appreciated.

Thanks

 

[SQLSister]

try

select  DATENAME(month,  dtdate)

"NOTHING is more important in a database than integrity." ESquared

 

[genomon]

Instead of DATEPART, try DATENAME and then use LEFT(name,3).

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[genomon]

I posted the same time as SQL Sis (so didn't see her reply)- as usual, her solution is more elegant in its simplicity, and also the way to go.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[SQLSister]

Genomon I think you are right and dolodolo still might need to use the left function.

select  left(DATENAME(month,  dtdate),3) from cmrevision

"NOTHING is more important in a database than integrity." ESquared

 

[dolodolo]

Thanks All for a great and speedy response!!!!