I have tried both LocalDateTime (without time zone informatio) and ZonedDateTime (with time zone information) in the new java.time package and get a same error:
column "registeration_datetime" is of type timestamp without time zone but expression is of type bytea
Hint: You will need to rewrite or cast the expression.