YEAR(Ticket_date) = YEAR(getdate()) and
MONTH(Ticket_date) = MONTH(getdate())
但我也将当前日期保存在变量中,以保证getdate()
在午夜执行长查询时结果不会改变
declare @today datetime = getdate()
...
YEAR(Ticket_date) = YEAR(@today) and
MONTH(Ticket_date) = MONTH(@today)
如何查看日期是否在当前月份的SQL Server中?
YEAR(Ticket_date) = YEAR(getdate()) and
MONTH(Ticket_date) = MONTH(getdate())
但我也将当前日期保存在变量中,以保证getdate()
在午夜执行长查询时结果不会改变
declare @today datetime = getdate()
...
YEAR(Ticket_date) = YEAR(@today) and
MONTH(Ticket_date) = MONTH(@today)