access与SqlServer 之时间与日期及其它SQL语句比较

<%'**********************************************'小结：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=0

    ACCESS实例：    select * from table where not finished

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

----------------------------------------------------------------------------

4、求余数

    1.access:       a mod b＝1002.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()

    ACCESS实例：    select   now()

    sqlserver实例： select getdate()

----------------------------------------------------------------------------%>

注：本文转自http://blog.csdn.net/flashasp/archive/2007/01/23/1490885.aspx