| Java JSP ORACLE Hibernate Servlet Struts Spring MySQL Java Script Post New Topic | |
| Category | Java |
| Asked By : | Ramakrishna Asked Date : Mar 25 2010 |
| Brief Desc: | Query to retrieve data between to dates |
| Details: | Dear Sir,
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. With Regards Ramakrishna Y |
