date function can change from date1 to date2

Question

Hi ,i need a sql server function can change date for example pass-->'2014-08-24' and get '2014-01-01'

Sachin Singh · Accepted Answer

yes it is very simple just use dateadd two times. select dateAdd(day,-((day( '2014-08-24' ))-1),dateadd(month,-( (month( '2014-08-24' ))-1),  '2014-08-24' ))

marco solidar · Answer

i use this code but i think is not practically    declare @cc int; set @cc =cast(DATEPART(YEAR,'2014-06-06')as int); declare @date11 date;set @date11= cast( @cc as varchar); select @date11      i get 2014-01-01