Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Two Dates Different values retrive
Senzeye
Mar 30 2016 9:19 AM
451
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
How to create sub menu for this code?
html5 line charts bind from database ?