SQL Server的Datediff和Access的Datediff的区别

最新推荐文章于 2024-04-16 11:45:05 发布

aspgreener

最新推荐文章于 2024-04-16 11:45:05 发布

阅读量1k

点赞数

分类专栏： SQL SERVER 文章标签： sql server access google function table sql

SQL SERVER 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

SQL Server的Datediff和Access的Datediff的区别

<script type="text/javascript">google_ad_client = "pub-2048279401139630";google_ad_slot = "8856771542";google_ad_width = 728;google_ad_height = 90;document.write("<s"+"cript type='text/javascript' s"+"rc='http://pagead2.googlesyndication.com/pagead/show_ads"+"."+"js'></scr"+"ipt>");</script>

What function does: returns a variant to reflect the time difference between two dates

Syntax: DateDiff( inteval, firstdate, seconddate [,firstweekday[ [ , firstweek])

Example

The following shods the difference in days between two dates:

= DateDiff("d", "11-05-2002", "11-07-2002") returns 2

The following table lists the valid time periods and their interval values.

Time Interval Syntax
Year
yyyy

Quarter
q

Month
m

Day of year
y

Day
d

Weekday
w

Week
ww

Hour
h

Minute
n

Second
s

Note: Take special care for "ww" vs "w." "WW" is for a week.

AgeYrs: DateDiff("d",[INSERVICE],Now())/365
Gives me this result:

14.5972602739726

in SQL the function:

AgeYrs = DATEDIFF(d,INSERVICE,getdate())/365

其实就是"需要注意！