Hello, I have a datetime column that has values such as shown below as a sample 04MAY2018:08:46:20.316999912 11JAN2021:11:07:37.048000097 17MAR2019:00:24:55.558000088 how do I filter the whole table based on the above column date range say between 04MAY2018 AND 17MAR2019? I tried this: WHERE DATE BETWEEN "04MAY2018"d AND "17MAr2019"d but it doesn't work. Please help.. thank you.
... View more