<how to compare only by date (without time) in joo...

# stackoverflow

[user]

how to compare only by date (without time) in jooq?
I have column with type timestamp with time zone. The table contains the following value "2022-06-30 225629.183764 +00:00". I want to do a date-only search.
how to compare only by date (without time) in jooq?
I've tried this, but it doesn't work.
.where(MY_TABLE.UPDATED_AT.cast(LocalDate::class.java).eq(cashDate))