字段:进出时间
类型:datatime
格式:2000-01-01 00:00:00
SLQ:"select dtb where 进出时间 between '" +DateTime.Now.Date+ " 00:00:00' and '" +DateTime.Now.Date+ "23:59:59'";
为什么取不出,当天的记录,说格式不对,请问应该怎么改?
类型:datatime
格式:2000-01-01 00:00:00
SLQ:"select dtb where 进出时间 between '" +DateTime.Now.Date+ " 00:00:00' and '" +DateTime.Now.Date+ "23:59:59'";
为什么取不出,当天的记录,说格式不对,请问应该怎么改?
缺少from表
请问,格式应该怎么转?
and 进出时间 < dateadd(day,1,convert(datetime,convert(varchar(8),getdate(),112)))
select dtb where 进出时间 between cast('" +DateTime.Now.Date+ " 00:00:00' as datetime) and cast('" +DateTime.Now.Date+ "23:59:59' as datetime)
'" +DateTime.Now.ToShortDateString()+ "' and '" + DateTime.Now.AddDays(1).ToShortDateString() +'";OR"SELECT * FROM Table WHERE [进出时间]>=
'" +DateTime.Now.ToShortDateString()+ "' and [进出时间]<'" + DateTime.Now.AddDays(1).ToShortDateString() +'";
"SELECT * FROM Table WHERE [进出时间] between
'" +DateTime.Now.ToShortDateString()+ " 02:30:00' and '" + DateTime.Now.AddDays(1).ToShortDateString() +" 03:30:00 '";
CTime tm1, tm2; str.Format(_T("select dtb where [进出时间] >= #%s# and [进出时间] <= #%s %s#"),
tm1.Format("%Y-%m-%d"),
tm2.Format("%Y-%m-%d"),
_T("23:59:59"));
select dtb from 表 where 进出时间>CONVERT(char(10),GETDATE(),120) and 进出时间<CONVERT(char(10),DATEADD(day,1,GETDATE()),120)试试!