How to get first day of month

Home >> Dababase Interview Questions >> Sql Server 2000 Query

Posted on December 15th , 2009 by Admin

	select CAST(CAST(YEAR(getdate()) AS VARCHAR(4)) + '/' + CAST(MONTH(getdate()) AS VARCHAR(2)) + '/01' AS DATETIME)