您好，

Hi,

Select * From Your_Table_Name where Year(Your_Date_Field)=Year(getDate()) And Month(Your_Date_Field)=Month(getDate())

当前月份:

Current month:

SELECT * FROM myTable WHERE myDate > DATEADD(DAY, -DAY(GETDATE()), GETDATE())

今天:

Today:

SELECT * FROM myTable WHERE myDate > DATEADD(Day, 0, DATEDIFF(Day, 0, GetDate()))

表和列已更改为通用名称-OriginalGriff [/EDIT]

Table and column changed to generic names - OriginalGriff[/EDIT]