Trimming a data field

[renee35]

I have the below formula:

CONVERT(varchar(10), m.DOB, 101) that returns:

12/23/2008, how can I get it to return only 12/2008?

Thanks!

Thanks a bunch!!

-T

 

[JohnDTampaBay]

There is no CONVERT style for that. You will have to do it manually. Try this:

CONVERT(Month(m.DOB), varchar(2))+'/'+CONVERT(Year(m.DOB), char(4))

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[renee35]

Thanks! I had to rearrange it like this in order to get it to work,

Convert(VarChar(2),Month(m.DOB))+'/'+Convert(VarChar(4), Year(m.DOB))

Thanks a bunch!!

-T

 

[JohnDTampaBay]

Sorry about that. I wrote them as CASTs, then decided to change to CONVERTs mid-post. Glad you figured it.

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[softhemc]

Alternatively ...

SELECT Right(Convert(varchar(10), m.DOB, 103), 7)