vb access筛选整点数据
access中数据如:
日期
2006/3/4 18:00:50
2006/3/4 18:05:50
2006/3/4 18:10:50
2006/3/4 17:05:50
2006/3/4 17:35:50
2006/3/4 17:40:50
2006/3/4 17:45:50
2006/3/4 17:50:50
2006/3/4 18:15:50
2006/3/4 18:20:50
2006/3/4 18:25:50
2006/3/4 18:30:50
2006/3/4 18:35:50
2006/3/4 18:40:50
2006/3/4 18:45:50
2006/3/4 18:55:50
2006/3/4 19:00:50
2006/3/4 19:05:50
2006/3/4 19:10:50
2006/3/4 19:15:51
2006/3/4 19:20:50
2006/3/4 19:25:50
2006/3/4 19:30:50
2006/3/4 19:35:50
2006/3/4 19:40:50
2006/3/4 19:45:50
2006/3/4 19:50:50
2006/3/4 19:55:50
2006/3/4 20:00:50
2006/3/4 20:05:50
2006/3/4 20:10:50
2006/3/4 20:15:50
2006/3/4 20:20:50
2006/3/4 20:25:50
2006/3/4 20:30:50
2006/3/4 20:35:50
2006/3/4 20:40:50
2006/3/4 20:45:50
2006/3/4 20:50:50
2006/3/4 20:55:50
2006/3/4 21:00:50
2006/3/4 21:05:50
2006/3/4 21:10:50
2006/3/4 21:15:50
2006/3/4 21:20:50
如何利用select筛选整点数据 高手帮忙看下,不甚感激!!
[解决办法]
strSQL = "select dayrq,wdtm from Tableqxcjsj where Minute(dayrq)=0"