截取日期问题

[hgxlucky]

我的submitedate为 类似 2008-7-25 13:35:28 这种格式，可是我在查询时为固定的日期，比如说输入2008-7-25，下面的语句应该怎样改呢？

select * from salesOrder where submitdate like '%"&request("sbdate")&"%' order by id

[sheyanfen]

select * from salesOrder where datediff(d,submitdate,'" &request("sbdate")&"')=0 order by id

[sheyanfen]

sql = "select * from salesOrder where datediff(d,submitdate,'" &request("sbdate") &"')=0 order by id"

[sy_binbin]

SQL数据库:sql = "select * from salesOrder where datediff(d,submitdate,'" &request("sbdate") &"')=0 order by id"

ACCESS数据库:sql = "select * from salesOrder where datediff('d',submitdate,'" &request("sbdate") &"')=0 order by id"

[jhwcd]

sql = "select * from salesOrder where datediff('d',submitdate,'" &request("sbdate") &"')=0 order by id"

[sd5816690]

任何数据库：
select * from salesOrder
where submitdate >= '"&request("sbdate")&"' and submitdate <= '"&request("sbdate")&" 23:59:59'

[ld2099]

between 日期 and 日期＋1 也可以

[Anlige]

[Quote=引用 4 楼 jhwcd 的回复:]
SQL codesql = "select * from salesOrder where datediff('d',submitdate,'" &request("sbdate") &"')=0 order by id"
[/Quote]