开发者

SQL DATEDIFF Not working?

开发者 https://www.devze.com 2022-12-25 03:16 出处:网络
I am running a simple DATEDIFF query but it doesn\'t seem to calculate the days properly or i\'m doing something wrong.

I am running a simple DATEDIFF query but it doesn't seem to calculate the days properly or i'm doing something wrong.

If I run

PRINT DATEDIFF(Day, 2010-01-20, 2010-01-01)
RETURN 19

Which is correct. If i change the month in the first date to Feb (02) I get something strange.

PRINT DATEDIFF(Day, 2010-02-20, 2010-01-01)
RETURN 20

Now shouldn't it be 48 or something?

Can anyone see what i'm doing wrong or is this not the correct function to be using if I want the No of days between these dates?

I've tried taking one date from the other:

PRINT (2010-02-20) - (2010-01-01)
RETURN 开发者_Go百科-20

Any help much appreciated.

Thanks J.


You are missing quotes

PRINT DATEDIFF(Day, '2010-01-01', '2010-02-20')

You're getting 20 because

2010 - 1 - 1 = 2008
2010 - 2 - 20 = 1988

2008 - 1988 = 20


If you run it this way:

SELECT  2010-02-20, 2010-01-01

you will see

1988  2008

which are results or the integer operations that you put here.

Enclose the date constants into single quotes:

SELECT  DATEDIFF(Day, '2010-02-20', '2010-01-01')

--
-50


It works if you surround your dates with apostrophes -

SELECT DATEDIFF(day, '2010-02-20', '2010-01-10')

-41


PRINT DATEDIFF(Day, '2010-01-10', '2010-02-20') 

That takes 2nd date - first date. Don't forget ' '.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号