If a date is in the format 2020-01-01 00:00:00.000, when we do [Date] <= '2020-01-01', it will not return 2020-01-01 00:00:01.000.
Is that corrent?
Shouldn't the 2020-01-01 00:00:01.000 be considered as '2020-01-01' ?
At the same time, if I do CONVERT(date,[Date]) <= '2020-01-01', this will return the 2020-01-01 00:00:01.000.
Is there a way to specify a global conversion of dates with a single line statement without having to repeat numerous CONVERT(date,[Date]) statements? E.g. IIF Table.* IS DATE THEN CONVERT(date,*)