asp中怎么查询日期类型的数据？

[blue781]

asp+access

库结构：

字段名 类型 默认值
id 自动编号
name 文本
cdate 日期/时间 Date()

我怎么查出cdate等于今天（取系统日期）的人呢？

sql语句怎么写？

[dh20156]

SELECT *
FROM [TABLE]
WHERE (DATEDIFF(d, cdate, GETDATE()) = 0)

[hj3793]

select * from table where cdate = #date()#
我也没试过，你看一下

[ronakitty]

SELECT *
FROM [TABLE]

WHERE (DATEDIFF(d, cdate, DATE()) = 0)或WHERE (DATEDIFF("d", cdate, DATE()) = 0)记不清了

[blue781]

各位大虾我要想下面那样应用：
<%
sql="select name from guest where" '这里的条件怎么写
rs.open sql,conn,1,1
%>

怎么些那个条件啊

[dh20156]

sql="SELECT * FROM [TABLE] WHERE (DATEDIFF(d, cdate, GETDATE()) = 0)"
GETDATE()是SQL里边取得当前时间的函数，如果你的是ACCESS你可以写NOW()

[777dragon]

try:

sql="select name from [guest] where cdate like #"&Date()&"#"

or

sql="select name from [guest] where (DATEDIFF('d',cdate,DATE())=0)"

[moonvan]

if len(bbb)>6 and bbb<>"" and isdate(bbb) then
sql="select name from guest where and [date] = "&"'"&bbb&"'"
end if

[angelyujun]

sql="select * from [table] where cdate=#"&date()&"#"