
good morning, iam using the code given below in mysql,but that retuned zero rows selected
select * from leavetable where leave_type in ('Sick Leave(SL)','Half Day Leave(HL)','Leave(L)') and currentdate='curdate()'
but have one row in leavetable like-
Leave(L) 100 John 2011-06-28
i wan't to display the employees on leave in current date.please help me and send me the currect code
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.