如何进入:
如果我使用SQL,我将编写以下查询(知道如何用U编写它吗?):
WHERE MyDate BETWEEN DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE())-1, 0) AND DATEADD(MONTH, DATEDIFF(MONTH, 0, getdate()), 0)
发布于 2020-10-29 11:02:33
为此,可以使用C#表达式:
DECLARE @startDayThisMonth DateTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
DECLARE @startDayPreviousMonth DateTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month - 1, 1);
@data =
SELECT
x
FROM
y
WHERE
MyDate BETWEEN @startDate AND @endDate;例子可以在本站上找到。
https://stackoverflow.com/questions/63941248
复制相似问题