Hi
I want to show Date and one field value from database in a drop down. I am using jstl for this in my
jsp page.
My query is like this:
select product_name from Product where production_timestamp > to_date('2005-10-25 00:00:00','yyyy-MM-dd hh24:mi:ss') and production_timestamp < to_date('2005-10-25 23:59:59','yyyy-MM-dd hh24:mi:ss')
I have to show the products produced for a particular day.
The query has to pick a current time stamp dynamically when I execute the jsp page.
Any suggestions.
SP Nam