access和SqlServer 关于时间的SQL语句比较

1.1算出日期差： 
1.access:?????? datediff('d',fixdate,getdate()) 

2.sqlserver:??? datediff(day,getdate())

 ACCESS实例：??? select * from table where data=datediff('d',getdate()) 
sqlserver实例： select * from table where data=datediff(day,getdate()) 
1.2算出时间差： 
1.access:?????? datediff('h',getdate()) 
2.sqlserver:??? datediff(Hour,'2004-12-10',getdate()) 

ACCESS实例：??? select DATEDIFF('h',HMD,getdate()) 
sqlserver实例： select datediff(Hour,getdate()) 

1.3算出月份差： 
1.access:?????? datediff('m',getdate()) 
2.sqlserver:??? datediff(Month,getdate()) 

ACCESS实例：??? select DATEDIFF('m',getdate()) 
sqlserver实例： select datediff(Month,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 finished 

2.sqlserver:??? finished=0 
ACCESS实例：??? select * from table where not finished 

sqlserver实例： select * from table where finished=0 

4、求余数 
1.access:?????? a mod b＝100 

2.sqlserver:??? a % b ＝100 
ACCESS实例：??? select?? a mod b＝100 from table where not finished 

sqlserver实例： select a % b ＝100 from table where finished=0 

5、获取当天日期 
1.access:?????? now() 
2.sqlserver:??? getdate() 

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!