Hello, I am trying to do a select with this condition but it is not working.
LocalDateTime endDate = null;
Table POST
ID NUMBER
DATE_END TIMESTAMP(6)
select p.id from post p where (:endDate is null or p.date_end < :endDate);
but when endDate is null I got the error ORA-00932 inconsistent datatypes expected TIMESTAMP got NUMBER.
Please help, thanks!