Hi guys
How can I return results just for PM times from my database?
Select * FROM bookings WHERE Date_Of_Actual_Booking=''
The field is DATETIME
Regards
Chris
Hi guys
How can I return results just for PM times from my database?
Select * FROM bookings WHERE Date_Of_Actual_Booking=''
The field is DATETIME
Regards
Chris
it would help a lot to know which database system you’re using
DB2? PostgreSQL? Sybase?
We are using mysql
ah, i see
well, for future reference, we have two database forums – MySQL forum (for MySQL), and Databases forum (for everything else)
i’ll ask a moderator to move your thread for you
try this –
WHERE TIME(Date_Of_Actual_Booking) >= '12:00:00'