mysql - compare date from database with value i get from inputtext in java jsp and sql -
i have table , there 4 fields: name
, start date , time
(timestamp) ,end date , time
(timpestamp) , car
.
in java/mysql,
i need compare database start date time , end start date time , compare value given in textbox date time field .
now problem need book person(driver) , car, if car , person not booked in given time (that checked database) , can booked else not.
please tell me logic/query this. if have code please mention it.
try query,
select name table having '2014-11-28' between start_date , end_date;
Comments
Post a Comment