Home >Database >Mysql Tutorial >access与SqlServer 时间日期比较

access与SqlServer 时间日期比较

WBOY
WBOYOriginal
2016-06-07 15:45:341554browse

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 tabl

    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 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()

    ACCESS实例:    select   now()

    sqlserver实例: select getdate()

access与SqlServer 时间日期比较

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn