Sql Calculation Help

[Srecruiter]

friends,
manam ee date select chesthe say 06/05/2013 naku previous year same date ki data ravali..like 06/05/2012.
i used DATEADD('year',-1,[Date]) adi date ni marusthundi kani danki related date ivatamledu 06/05/2013 data ney isthundi

[150bryant]

Use DT > '06/05/2012' and DT < '06/05/2013'

[ghazni]

enduku ivatledu istundi kada select DATEADD(year,-1,'6/5/2013')

2012-06-05 00:00:00.000

[Bairagi From Bapatla]

[quote name='Jadoo' timestamp='1370454305' post='1303825691']
friends,
manam ee date select chesthe say 06/05/2013 naku previous year same date ki data ravali..like 06/05/2012.
i used DATEADD('year',-1,[Date]) adi date ni marusthundi kani danki related date ivatamledu 06/05/2013 data ney isthundi
[/quote]
nu cheppindi where clause lo isthe aa data vasthadi kada....

[pinky123]

[size=4][font=arial, sans-serif]select * from <TBL_NAME> where <DATE_COL>=conv[/font][font=arial, sans-serif]ert(date, dateadd(year, -1, '06/05/2013'))[/font][/size]