从sql server中选择日期范围为昨天和当前的值。 [英] Select values from sql server where date range is yesterday and current.
本文介绍了从sql server中选择日期范围为昨天和当前的值。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何从我的SQL服务器中选择仅包含昨天的日期,今天
例如我只会选择昨天的值,
3月4日
和今天
3月5日
这里是我到目前为止所得到的:
How do I select from my SQL server with dates only from yesterday, and today
for example I will only select values from yesterday,
MARCH 4
and today
MARCH 5
here's what I've come up so far:
SQcmd = new SqlCommand("SELECT COUNT(*) as 'count' FROM dbo.INVENTORY WHERE INV_NO is NULL where AGT_INV_DATE=", SQcon);
AGT_INV_DATE是我需要过滤的日期。
AGT_INV_DATE are the dates that I need to filter.
推荐答案
将您的where子句更改为:
Change your where clause to:
WHERE AGT_INV_DATE
BETWEEN
DATEADD(day, DATEDIFF(day,0,GETDATE())-1,0)
AND
DATEADD(day, DATEDIFF(day,0,GETDATE()),0)
SELECT COUNT(*) as 'count'
FROM dbo.INVENTORY
WHERE INV_NO IS NULL AND AGT_INV_DATE BETWEEN DATEADD(dd, -1,GETDATE()) AND GETDATE()
详情请见:日期和时间数据类型和函数(Transact-SQL) [ ^ ]
SELECT * FROM INVENTORY WHERE INV_DATE BETETEET GETDATE() - 1和GETDATE()
这篇关于从sql server中选择日期范围为昨天和当前的值。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文