How to get rows with current date in sql?

Question

SQL Server

there is a sql query.
SELECT Userid FROM Checkinout Tell me

how to abyss WHERE CheckTime = "2020.06.18" to get all rows for the specified day?

Answer 1

Classic variant:

where cast(datetime_field as date) = cast(getdate() as date)

Naturally, we leave the bottom of the iceberg behind the scenes in the form of timezones, etc.

Answer 2

SELECT Userid FROM Checkinout where CheckTime like '2020.06.18%'