Tuesday, January 10, 2012

Convert DateTime to Month/Year(SQLServer)


Convert DateTime to Month/Year(SQLServer)

select convert(varchar(2),datepart(month,getdate())) + '/' +
convert(varchar(4),datepart(year,getdate())) 

No comments:

Post a Comment