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