Convert date to YYYYMM 1

[LonnieJohnson]

How do I return 201201 from 01/15/2012? Or 201204 from 04/21/2012?

I was able to get 20121 or 2012 by combining the YEAR and MONTH but I want two character month no matter what month it is.

Thanks.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[LonnieJohnson]

I found it.

Select Replace(Convert(VarChar(7), GetDate(), 120), '-', '')

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[r937]

SELECT CONVERT(VARCHAR(6),GetDate(),112)

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[LonnieJohnson]

Thanks r937, that is more efficient.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!