选择从月初到当前日期的记录

Question

我正在尝试选择在当月初和当天之间添加到数据库中的记录-我或多或少知道如何从当天和特定时间段内获取记录-但是我如何获取它，以便从当前日历月初开始？

Answer 1

DECLARE @sm DATETIME;
SET @sm = DATEADD(DAY, 1-DAY(GETDATE()), DATEDIFF(DAY, 0, GETDATE()));

SELECT columns 
    FROM dbo.foo 
    WHERE datetime_column >= @sm;

Answer 2

WHERE YEAR([Date])=YEAR(GETDATE())
AND MONTH([Date])=MONTH(GETDATE())
AND DAY([Date])<=DAY(GETDATE())

Answer 3

select *
from YourTable
where DateCol >= dateadd(month, datediff(month, 0, getdate()), 0)