DateTime filters are truncating time.
passedValue: 2023-06-29T14:00:00.000Z&2023-06-30T14:00:00.000Z
Generated Query:
WHERE CONVERT(date, [t].[colName]) >= '2023-06-29T00:00:00.0000000+01:00' AND CONVERT(date, [t].[colName]) <= '2023-06-30T00:00:00.0000000+01:00'
passed Value : 2023-06-29T13:00:00.000Z
Generated Query:
WHERE CONVERT(date, [t].[colName]) = '2023-06-29T14:00:00.0000000+01:00'
DateTime filters are truncating time.
passedValue: 2023-06-29T14:00:00.000Z&2023-06-30T14:00:00.000Z
Generated Query:
WHERE CONVERT(date, [t].[colName]) >= '2023-06-29T00:00:00.0000000+01:00' AND CONVERT(date, [t].[colName]) <= '2023-06-30T00:00:00.0000000+01:00'
passed Value : 2023-06-29T13:00:00.000Z
Generated Query:
WHERE CONVERT(date, [t].[colName]) = '2023-06-29T14:00:00.0000000+01:00'