<%'**********************************************'小结：access与SqlServer 之时间与日期及其它SQL语句比较'作者：flashasp，工作中总结'**********************************************1、Datediff：
1.1算出日期差：1.access: datediff('d',fixdate,getdate())2.sqlserver: datediff(day,fixdate,getdate())ACCESS实例： select * from table where data=datediff('d',fixdate,getdate())sqlserver实例： select * from table where data=datediff(day,fixdate,getdate())
1.2算出时间差：1.access: datediff('h',fixdate,getdate())2.sqlserver: datediff(Hour,'2004-12-10',getdate())ACCESS实例： select DATEDIFF('h',HMD,getdate())sqlserver实例： select datediff(Hour,'2004-12-10',getdate())
1.3算出月份差：1.access: datediff('m',fixdate,getdate())2.sqlserver: datediff(Month,'2004-12-10',getdate())ACCESS实例： select DATEDIFF('m',HMD,getdate())sqlserver实例： select datediff(Month,'2004-12-10',getdate())----------------------------------------------------------------------------
2、日期变量1.access: #"&data&"#2.sqlserver: '"&data&"'ACCESS实例： select * from table where data=#"&data&"#sqlserver实例： select * from table where data='"&data&"'----------------------------------------------------------------------------
3、是否1.access: not finished2.sqlserver: finished=0ACCESS实例： select * from table where not finishedsqlserver实例： select * from table where finished=0----------------------------------------------------------------------------
4、求余数
1.access: a mod b＝1002.sqlserver: a % b ＝100ACCESS实例： select a mod b＝100 from table where not finishedsqlserver实例： select a % b ＝100 from table where finished=0----------------------------------------------------------------------------
5、获取当天日期1.access: now()2.sqlserver: getdate()ACCESS实例： select now()sqlserver实例： select getdate()----------------------------------------------------------------------------%>
注：本文转自 http://blog.csdn.net/flashasp/archive/2007/01/23/1490885.aspx