Select by Date range of dates

Asked May 21 '16 at 18:51

Active May 21 '16 at 18:51

Viewed 35 times

I want to select PostgreSQL rows based on Date range. I tried this:

Date start;
Date end;

ps = conn.prepareStatement("SELECT * FROM SCHEDULE WHERE START_DATE = ? AND END_DATE = ?");

ps.setDate(1, (java.sql.Date) start);
ps.setDate(2, (java.sql.Date) end);

But I get

java.lang.ClassCastException: java.util.Date cannot be cast to java.sql.Date
    at com.crm.web.schedule.Schedule$1.loadEvents(Schedule.java:62)

How I can properly select range of dates?

asked May 21 '16 at 18:51

Peter Penzov

1,126
134
430
808

ps.setDate(1, new java.sql.Date(start.getYear(), start.getMonth(), start.getDay())); ps.setDate(2, new java.sql.Date(end.getYear(), end.getMonth(), end.getDay())); – Mesbah Gueffaf May 23 '16 at 07:38
I get the same wrong result. – Peter Penzov May 23 '16 at 07:57
then ps.setDate(1, start); ps.setDate(2, end); – Mesbah Gueffaf May 23 '16 at 12:24
I get error that I need to cast the dates from util to sql date. – Peter Penzov May 23 '16 at 12:28

Select by Date range of dates

0 Answers0