ludah Posted January 22, 2015 Share Posted January 22, 2015 SELECT * FROM `booking_tbl` WHERE booking_status = 'Check In' AND departure_date_time = NOW()" I use the datetime datatype for the departure_date_time so i can get data from that data because it checking the date and time but i want it to check on the date from the datetime datatype So how can i get the data only with that date without the time in the mysql datetime datatype Link to comment https://forums.phpfreaks.com/topic/294139-selecting-all-data-of-a-specific-date-from-mysql-datetime/ Share on other sites More sharing options...
Barand Posted January 22, 2015 Share Posted January 22, 2015 ... WHERE DATE(departure_date_time) = CURDATE() Link to comment https://forums.phpfreaks.com/topic/294139-selecting-all-data-of-a-specific-date-from-mysql-datetime/#findComment-1503737 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.