- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_select_reg`(In date1 varchar(50),In date2 varchar(50))
- BEGIN
-
- select * from `reg` where date > cast(date1 as datetime) and date < cast(vvsysdate as date2) ORDER BY date ASC;
-
- END
date values does't retrived correct vales from database .
my date format is dd/MM/yyyy
how can i solve this problem ?. please help me.