How to get correct date part from variable sql

Question

There is a need to get the year,month and day part from a date variable.when fired the below query ,it gives day as 8 and month as 4

declare @date1 datetime
set @date1='04/08/2014'
        ------'dd/mm/yyyy' 

--select @date1,year(@date1) year1,month(convert(@date1,datetime)) month1,day(@date1) day1
select   YEAR(CONVERT(DATETIME,@date1)) YEAR1,
            MONTH(CONVERT(DATETIME,@date1)) MOTNH1,
            DAY(CONVERT(DATETIME,@date1)) DAY1
FROM            Tab1

Answer 1

Check this for DateTime possible formats

declare @date1 datetime
set @date1=CONVERT(DATETIME,'04/08/2014',103)

SELECT  YEAR(@date1) YEAR1,
        MONTH(@date1) MOTNH1,
        DAY(@date1) DAY1

Make a note thar dd/MM/yyyy is different than dd/MM/yy. The first need 103 as the format switch and the latter needs 3.