在SQL Server CE中表示时间跨度的最佳方法是什么？

datetime

CREATE TABLE my_table (
    id INT PRIMARY KEY,
    date_range datetime
);

DateTime dateRange = new DateTime(2022, 1, 1);

let dateRange = new Date(2022, 1, 1);

date_range = datetime.date(2022, 1, 1)

$dateRange = new DateTime('2022-01-01');

Date dateRange = new Date();
Calendar cal = Calendar.getInstance();
cal.set(Calendar.YEAR, 2022);
cal.set(Calendar.MONTH, 0);
cal.set(Calendar.DATE, 1);