Hi,
I have one table with 3 fields
Id - int
Name - varchar
JoinDate - datetime
Id   Name  JoinDate
1     a        2022-07-13 12:00:00
2      b       2022-07-13  9:30:00
3      c       2022-07-13  7:30:00
My requirement need to filter joindate values with date only
Can you please provide me sample query
Declare @FromDate datetime
Set @FromDate = '2022-07-13 13:39:31.757'
select * from Employee where JoinDate = @FromDate