between filter doesn't work properly if the date column format doesn't matches with the min & max value

[nextchamp-saqib]

select * from table where creation between '2024-01-01 00:00:00' and '2024-01-31 23:59:59' will not include rows were creation is equal to 2024-01-01 00:00

it will only include if creation = '2024-01-01 00:00:00' or if the min & max values of between filter is changed to '2024-01-01 00:00' and '2024-01-31 23:59'