Printing mm/yyyy from a date field 1

[luvmy2kids]

How can I get the date field to only print the mm/yyyy as opposed to the entire date?

Thanks!

 

[luvmy2kids]

This is what I have and it is giving me this error:

Incorrect syntax near the keyword 'Convert'.

Convert(VarChar(2),Month(getdate()))+'/'+Convert(VarChar(4), year(getdate()))

 

[markros]

First idea that comes to mind is

select cast(month(dtField) as char(2)) + '/' + cast(year(dtField) as char(4)) as MonthYear

 

[luvmy2kids]

Nevermind~ I was leaving the "Select" off..

 

[gmmastros]

there's probably 100 different ways. I preference is...

Select Right(Convert(VarChar(10), GetDate(), 103), 7)

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[dnfrantum]

Thanks gmmastros. Your post helped me tremendously. I couldn't remember this syntax. I used Right(Convert(VarChar(15), GETDATE(), 106), 8) to return the following format:

JUN 2009

BTW, you get a star.

Thanks in advance,
Donald