access数据库datetime类型查询方法

String sql = "select t.emp_id,e.emp_name,t.sign_time from TimeRecords t,Employee e where t.emp_id=e.emp_id and e.emp_name like '%"

+ ""

+ "%' and t.sign_time>="

+ "#2012-01-01#"

+ " and t.sign_time <=" + "#2013-02-02#";

 

如上在日期类型两边加上#号