Link to home
Create AccountLog in
Avatar of keplan
keplanFlag for Australia

asked on

DATEDIFF FUNCTION

Hi,

Could someone help me to get the folowing answer from datediff function.

I havea two date on my source data, the format is as below:

2008-01-24 00:00:00.000      2008-01-25 00:00:00.000


I want to get the answer = 2 from the datediff.

How do I achieve this?

Thanks.
SOLUTION
Avatar of Chris Mangus
Chris Mangus
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Then my query should work fine.
Avatar of keplan

ASKER

excellent
Avatar of keplan

ASKER

thanks