3
Answers

Two Dates Different values retrive

Senzeye

Senzeye

8y
467
1
  1. CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_select_reg`(In date1 varchar(50),In date2 varchar(50))  
  2. BEGIN  
  3.   
  4. select * from `reg` where date > cast(date1 as datetime) and date < cast(vvsysdate as date2) ORDER BY date ASC;  
  5.   
  6. 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.
Answers (3)