[[https://docs.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables?view=sql-server-ver16|temporal tables]] - auto versioning

====== common tasks ======

===== compare only dates of datetimes =====

SELECT TOP 1000 * FROM Trip WHERE Cast(AppointmentTime as date) = cast(CONVERT(varchar, '2023-01-09', 112) as datetime)