日期+时间段查换,SQL SERVER数据库,见下图:
叁考代码:
edate.Text = System.DateTime.Now.ToShortDateString();
bdate.Text = Convert.ToDateTime(edate.Text).AddDays(-0).ToShortDateString();
strsql = "select top 1500 * from qbdj_dljl where (CONVERT(CHAR(10),jldate,121)>='" + bdate.Text + "' or '" + bdate.Text + "'='' ) and (CONVERT(CHAR(10),jldate,121)<='" + edate.Text + "' or '" + edate.Text + "'='' ) ";
还有另一种方法:
edate.Text = System.DateTime.Now.ToShortDateString();
bdate.Text = Convert.ToDateTime(edate.Text).AddDays(0).ToShortDateString();
//结束时间多增加1天,解决查询不到结束当天记录问题
string bd = string.Format("{0:d}", bdate.Text);
string ed = string.Format("{0:d}", edate.Text);
ed = Convert.ToDateTime(ed).AddDays(1).ToShortDateString();
strsql = "select top 1000 * from dljl where (CONVERT(datetime, jldate)>='" + bd + "' or '" + bd + "'='' ) and (CONVERT(datetime, jldate)<='" + ed + "' or '" + ed + "'='' ) ";