Hi Here i tried a lot. there is a problem in date format. While am retrieving date from access to jsp. format is changed 2009-03-11 00:00:00 like this. I cant select and between queries in jsp. it shows wrong data. How to get date only from access.

Get two date start date and end date.

Apply that in select * from tablename where programdate between startdate and enddate.

but i cant retrieve that output exactly.

Thanks in Advance