search data by date in jsp from postgresql database

[jayanta21]

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?

[r035198x]

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 PreparedStateme nt to execute a query like "select col1,col2 from tableName where dateColumnName between ? and ? " and use a PreparedStateme nt parameters to set the boundary dates.

[Rabbit]

This thread has been moved to the postgresql forum.