asp 中between and 的用法 急 在线等
来源:百度知道 编辑:UC知道 时间:2024/05/06 18:44:12
怎么 找寻都为空
我想根据日期查找数据库里面在某个日期到某个日期的数据
<%
set rs=server.CreateObject("adodb.recordset")
bigin_t1=request.form("select")&"-"&request.form("select2")&"-"&request.form("select3")'&" 00:00:00"
bigin_t=cdate(bigin_t1)
h_t1=request.form("select4")&"-"&request.form("select5")&"-"&request.form("select6")'&" 23:59:59"
h_t=cdate(h_t1)
sql="select * from shfw where 提交时间 between "&bigin_t&" and "&h_t
rs.open sql,db
%>
我想根据日期查找数据库里面在某个日期到某个日期的数据
<%
set rs=server.CreateObject("adodb.recordset")
bigin_t1=request.form("select")&"-"&request.form("select2")&"-"&request.form("select3")'&" 00:00:00"
bigin_t=cdate(bigin_t1)
h_t1=request.form("select4")&"-"&request.form("select5")&"-"&request.form("select6")'&" 23:59:59"
h_t=cdate(h_t1)
sql="select * from shfw where 提交时间 between "&bigin_t&" and "&h_t
rs.open sql,db
%>
1、首先说明ASP中并没有between and的语法、函数和过程
2、你说的between and是指SQL语句中的,此语句适用于MSSQL数据库
3、between and语法在SQL语句中的用法示例是:
--select * from TABLE where date between '开始日期时间' And '结束日期时间'
--例如:
select * from TABLE where date between '2009-1-20' And '2009-1-22'
注意:上面的语句会出现一些问题,无法检索到2009-1-22日的任何数据,因为结束日期时间'2009-1-22'在sql语句中会默认为'2012-1-22 00:00:00.000'
正确的写法是:
select * from TABLE where date between '2009-1-20' And '2009-1-22 23:59:59.997'
4、between and语法等价于>=和<=的联合条件的简写。例如:
select * from TABLE where date between '2009-1-20' And '2009-1-22 23:59:59.997'
是和
select *&
asp 中between and 的用法 急 在线等
asp 中between and 的用法 (有变量的)
a cross between
There is a lake ( ) these countries.( )中填between 还是among ? Why?
Learning is a partnership between teachers students
急:A hedge between keeps feiendship green.
between the two windows hangs a picture
A Cultural contrast between America and Britain
the difference between A and B
Britain, a bridge between Europe and America