I can't be accurate from that little information, but have a look at the
DATEDIFF[
^] function - it lets you select what data you want.
For this week:
SELECT * FROM MyTable WHERE DATEDIFF(ww, MyDateColumn, GETDATE()) = 0
For month:
SELECT * FROM MyTable WHERE DATEDIFF(mm, MyDateColumn, GETDATE()) = 0
And Year:
SELECT * FROM MyTable WHERE DATEDIFF(yy, MyDateColumn, GETDATE()) = 0