By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,778 Members | 1,318 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,778 IT Pros & Developers. It's quick & easy.

search data by date in jsp from postgresql database

P: 1
Hi,
I have got a problem in jsp to search data by date from database which is in postgresql.what happen i have a field in database "date",now i am trying to search data in jsp page between two dates.how can i do that?
Jun 12 '13 #1
Share this Question
Share on Google+
2 Replies


10K+
P: 13,264
this is the DB2 forum so you should have asked this in Java or postgres forum.
SQL has a BETWEEN clause so just get the date and use a PreparedStatement to execute a query like "select col1,col2 from tableName where dateColumnName between ? and ? " and use a PreparedStatement parameters to set the boundary dates.
Jun 12 '13 #2

Rabbit
Expert Mod 10K+
P: 12,366
This thread has been moved to the postgresql forum.
Jun 12 '13 #3

Post your reply

Sign in to post your reply or Sign up for a free account.