I'm using DATEDIFF() function to find out difference in terms weeks between two dates, but it is working differently for different dates.
Please find below example.

```
select datediff(week,'2022-09-05T23:39:20.123-07:00', '2022-09-18T01:39:20.123-07:00');

```

above query will give output as 1 week.
but if above both dates are shifted by 2 days(as given in below query) then it gives output as 2 weeks

```
select datediff(week,'2022-09-07T23:39:20.123-07:00', '2022-09-20T01:39:20.123-07:00');

```

Why this is so? Could anyone please help on this?
Thanks.