添加昨天的日期参数 [英] add yesterday date parameter

问题描述

亲爱的，



我想知道，我怎样才能在下面获得以下sql server查询，以便在c＃中阅读：



从[dbo]中选择*。[数据库]其中UploadDate> =转换（nvarchar（10），getdate（） - 1,101）



我已经开始创建以下代码，但我不确定，如果这可能是正确的方法。任何帮助将非常感激。

Dear all,

I would like to know, how can i can get the following sql server query below, to be read in c#:

select * from [dbo].[database] where UploadDate >= Convert(nvarchar(10), getdate() - 1, 101)

I have started by of creating the following code but I am not sure, if this may be the right approach. Any help would be much appreciated.

var yesterday = DateTime.Today.AddDays(-1);
        string cmdstr = "select * from [dbo].[database] where UploadDate = 'yesterday' ";

推荐答案

我的方式是：

The way I do it is:

SELECT * FROM MyTable WHERE DATEDIFF(d, UploadDate, GETDATE()) = 1

DateAdd [ ^ ] MS Access停止工作的功能？不！

Did DateAdd[^] function for MS Access stop wroking? No!

SELECT DateAdd("d", -1, Date()) As Yesterday;

工作解决方案代码：

Working solution code:

var yesterday = DateTime.Today.AddDays(-1);
string cmdstr = "select * from [dbo].[database] where UploadDate = @value";
SqlCommand cmd = new SqlCommand(cmdstr, conn);
cmd.Parameters.AddWithValue("@value", yesterday);

这篇关于添加昨天的日期参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！