Question

Access中sql语句的时间函数的用法

如:
date time an
2001-1-1 0:00:00 1
2001-1-1 0:05:00 2
2001-1-1 0:10:00 3
这样一个表，我怎么才能查询到所有整点的an值？
结果如：
2001-1-1 0:00:00 1
2001-1-1 1:00:00 5
2001-1-1 2:00:00 10
我在线等，谢谢大家了。

Answer 1

比较简单的方法是
select an from talbe where time in ('0:00:00','1:00:00','2:00:00','3:00:00','4:00:00','5:00:00','6:00:00','7:00:00','8:00:00','9:00:00','10:00:00','11:00:00','12:00:00')

Answer 2

select an
from 表名
where second(time)=0 and minute(time)=0

Answer 3

select an from 表 where second(time)=0 and minute(time)=0

Answer 4

select * from 表 where second(time)=0 and minute(time)=0