Hey, you can do like
For Daily Write SQL Like
Select Day(getdate()) as Daily from table_name group by Daily
For Monthly Write SQL Like
Select Month(getdate()) as Monthly from table_name group by Monthly
For Yerly Write SQL Like
Select Year(getdate()) as Yearly from table_name group by Yearly
Just replay the getdate() Function with your date column name and table_name with your table name.
Thats ALL :-)