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)