Jump to content

Selecting all data of a specific date from mysql datetime


ludah

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.