access日期的查询
数据库中保存的是
date1
2009-12-31 15:19:00
2009-12-28 15:19:00
2009-05-31 15:19:00
2009-11-31 15:19:00
输入的查询值是2009-12-28
access怎样把这条数据查出来？
and val(date1) like '%" + dtpStartDate.Value.ToShortDateString() + "%'
不行
[解决办法]
select * from tt where format(date1,'yyyy-mm-dd')='2009-12-28'
[解决办法]
and int(date1)=#2009-12-28#
[解决办法]
是数据已经取到datatable了，再datatable里再进行查询对吗？
[解决办法]
and date1 BETWEEN #2009-12-28 00:00:00# AND #2009-12-28 23:59:59#
试试看
[解决办法]
date1 BETWEEN #2009-12-28 00:00:00# AND #2009-12-28 23:59:59#
或 date1 >#2009-12-28 00:00:00# AND datel<#2009-12-28 23:59:59#
[解决办法]
select * from tt where format(date1,'yyyy-mm-dd')='2009-12-28'
[解决办法]
admire！~
too short...
