Question

ACCESS 和SQL 查询语句 sql能用 ACCESS 不能 语句如下

select datediff(day, data_time, '" + DateTime.Now + "') from consumption a,(select max(data_time) as riqi from consumption ) b where b.riqi = a.data_time
不行的 是datediff问题吧!

Answer 1

select datediff(day, data_time, #" + DateTime.Now + "#) from consumption a,(select max(data_time) as riqi from consumption ) b where b.riqi = a.data_time

access中sql语句中的时间日期字段要用#，用#代替sql中的单引号。