|Java JSP ORACLE Hibernate Servlet Struts Spring MySQL Java Script Post New Topic|
|Asked By :||Ramakrishna Asked Date : Mar 25 2010|
|Brief Desc:||Query to retrieve data between to dates|
I have one problem, i have date stored in varchar datatype of (X) table in mysql as it was not supporting the date format of (dd/mm/yyyy) so know the problem is,
When i going to get the data between the the two dates it is giving the un reliable answers such that
when i am asking the query as data between 1st April to 31st December 2009 it is showing the data from the 2008 .
is there any way to solve this problem,please help this is an urgent requirement, your replay will be helpful to me.