WHERE 子句，用于获取 asp.net 中当前日期的月份和年份

Question

我想从sql数据库中按月份和年份过滤数据。我将当前日期设置为 (yyyy-MM-dd( 格式。从那里我想按月份和年份过滤。下面是我的源代码。

Dim ServerDate As String
ServerDate = Date.Now.ToString("yyyy-MM-dd")
Dim nowYear As Integer
nowYear = Date.Now.Year
Dim nowMonth As Integer
nowMonth = Date.Now.Month

这是我的选择语句：

cmd.CommandText = "Select COUNT(*) FROM ScanningData WHERE ASSET_NUMBER=" & AssetTxt.Text & " And LOC_DEPT=" & DeptCodeTxt.Text & " AND UNIT_NO=" & UnitNoTxt.Text & " AND UPDATE_DATE='" & nowMonth & nowYear & "';"    

有人可以帮助我吗？提前谢谢你

Answer 1

使用 DATEPART

例如(未测试语法错误(

Select COUNT(*) FROM ScanningData 
WHERE ASSET_NUMBER=" & AssetTxt.Text & " And LOC_DEPT=" & DeptCodeTxt.Text & " 
AND UNIT_NO=" & UnitNoTxt.Text & " AND ( DATEPART(mm, CreationDate) = "& nowMonth & ") and (DATEPART(yy, CreationDate)="& nowYear  & " )