I just need to select the first day of the month of a given datetime variable.
I know it's quite easy to do using this kind of code :
select CAST(CAST(YEAR(@mydate) AS VARCHAR(4))
+ '/' + CAST(MONTH(@mydate) AS VARCHAR(2)) + '/01' AS DATETIME)
but this is not very elegant, and probably not very fast either.
Is there a 'better way to do this ? (I'm using SQL Server 2008)