Access时间判断
记录一下,怕忘记了
SELECT * FROM table1 where [Start]> #3000-1-1#
update table1 set Start=#3010-1-1# where datediff('s',[Stamp],#3010-9-10 21:32:49#)=0
记录一下,怕忘记了
SELECT * FROM table1 where [Start]> #3000-1-1#
update table1 set Start=#3010-1-1# where datediff('s',[Stamp],#3010-9-10 21:32:49#)=0