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 Quote 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() Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.