In sql server 2019 version when we are using datetime data type column in where condition it’s giving 0 records.

We tried to convert it to datetime2 as well but no luck. As the milli/nano seconds are changing and not getting matched.

Is there any way we can match the datetime value and get results?

Select * from tab1 where date = ‘5/28/2024 5:08:17 PM’