Compare Mysql date with current date
I am implementing an application for online auctions, it is part of my essay @ the university.
I am using JSP/EL as basic tools. I want to compare the date that comes from mysql items table (start_date : the day that the auction starts) with the current date to check if the auction is started.
How to do that with JSP/EL ?
i can retrieve the data form mysql using JSTL sql tag and then pass it to a parameter e.g c:set var="start_date". But the problem is that this is a type of string and the current date is a type of java.util.date. How to convert them? in order to use EL to compare them..