KavyaVS
asked on
DateDiff is not working
I am trying to get days difference between two dates. The data type is SmallDatetime.
Select *
from dbo.Tbl1
where (DateDiff(day,Date1,Date2) > = 10)
It is not giving the correct results.How to make it work.
Thanks
Select *
from dbo.Tbl1
where (DateDiff(day,Date1,Date2)
It is not giving the correct results.How to make it work.
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER