Problems with Date, preparedStatement, JDBC and PostgreSQL

Question

I Have to get a movie from a PostgreSQL database that matches a given title and release date. title is a character(75) and releaseDate is a date. I Have this code:

String query = "SELECT * FROM \"Movie\" WHERE title = ? AND \"releaseDate\" = ?)";
Connection conn = connectionManager.getConnection();
PreparedStatement stmt = conn.prepareStatement(query);
java.sql.Date date = new java.sql.Date(releaseDate.getTime());
stmt.setString(1, title);
stmt.setDate(2, date);
ResultSet result = stmt.executeQuery();

but it's not working because the releaseDate is not matching when it should. The query SELECT * FROM "Movie" WHERE title = A_MOVIE AND "releaseDate" = A_DATE works perfectly on a command shell using psql

If releaseDate is a java.sql.Date, why copy it to date before calling setDate()? — trashgod
– trashgod, Commented Apr 3, 2010 at 4:07
What's the exact SQL column type of releaseDate? Is it really date? There is also timestamp. Which PostgreSQL DB version and JDBC driver version are you using? — BalusC
– BalusC, Commented Apr 3, 2010 at 4:11

GuidoMB · Accepted Answer · 2010-04-03 04:13:10Z

3

The problem was in the database because of time format was changed from dd/MM/YYYY to MM/dd/YYYY.

Thanks

answered Apr 3, 2010 at 4:13

GuidoMB

2,2215 gold badges27 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

trashgod Over a year ago

Aha! postgresql.org/docs/current/static/…

Collectives™ on Stack Overflow

Problems with Date, preparedStatement, JDBC and PostgreSQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related