Oracle JDBC date manipulation

Consider following SQL queries:   It seems both queries should be similar. Moreover, I thought the second one would be the fastest. However, the sample below shows another reality. With my data results are: Query 1: 1208 ms. Query 2: 20038 ms. Curious behaviour. Edited! An explanation can be always found (Spanish link): JDBC 9.x yContinue reading “Oracle JDBC date manipulation”