How to select distinct records from datetime column with with only date not time?

[PawanGhewande]

I want to select distinct dates from column which contain the DateTime together. I want distinct dates only and ignore time.

[simolus3]

I think date might be what you're looking for? If you want to select distinct dates, you could use selectOnly(yourTable, distinct: true)..addColumns([yourTable.dateColumns.date]). You could also group by this expression if needed.