sqlserver查询当月数据

SELECT * FROM table WHERE datediff(month,LoginTime,getdate())=0 ORDER BY LoginTime

SELECT * FROM table WHERE datediff(month,ApproveTime,getdate())=0 ORDER BY ApproveTime