How to retrieve data from database using a date

Asked Nov 14 '17 at 04:23

Active Nov 14 '17 at 05:27

Viewed 76 times

I use a calendar to input a date in a jsp file

<sj:datepicker id="startDate" name="startDate" readonly="true" maxDate="d" changeYear="true"
                                                           buttonImageOnly="true" displayFormat="dd-M-y" yearRange="2000:2200" />

As output it give date like this 09-Nov-17

But in the database the date looks like 09-NOV-17 as I used date data type.

I wrote the sql to find the data using data as follow

if (inputBean.getStartDate() != null && !inputBean.getStartDate().trim().isEmpty()) {
        where += " and c.startDate = '" + inputBean.getStartDate().trim() + "'";
    }

But it dose not filer the data from the database by search with the input date and also show no error. How can I over come from this.

edited Nov 14 '17 at 05:27

Bhanuchander Udhayakumar

1,581
1
12
30

asked Nov 14 '17 at 04:23

upeksha silva

are you not storing date as `Date` type in DB, and use `PreparedStatement`? – Saravana Nov 14 '17 at 04:25
convert the date in DB date type and then use query. – Tejendra Nov 14 '17 at 04:29
Covert date to java.sql.date in query. Look this it might help : https://stackoverflow.com/questions/530012/how-to-convert-java-util-date-to-java-sql-date – Chandan Rajput Nov 14 '17 at 05:32

How to retrieve data from database using a date

0 Answers0