mySQL: MYSQL Select time from a date - If you have a date field in mysql of format:<br /> <br /> 09/02/2005 13:52<br /> <br /> and you

Quick Search:

mySQL: MYSQL Select time from a date

Jump to:

Category: >> mySQL >> MYSQL Select time from a date

<< last

next >>

Snippet Name: MYSQL Select time from a date

Description: If you have a date field in mysql of format:

09/02/2005 13:52

and you wish to find events made between two times not between two dates, use the example query.

Comment: (none)

Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 01st, 2009

SELECT date_booking_made 
FROM WHERE HOUR(the_date)> 10 
AND MINUTE(the_date) > 10