Return PM results

Databases
1

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

2

it would help a lot to know which database system you’re using

DB2? PostgreSQL? Sybase?

3

We are using mysql

4

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'