MYSQL Select time from a date

Home >PHP MYSQL

MYSQL Select time from a date
04/01/2006

Consider you have a date field in mysql of format

date_booking_made

09/02/2005 13:52

and you wish to find all bookings made between two times not between two dates.

The solution is to issue the following query

SELECT date_booking_made from where hour(date_booking_made)> 10 and minute(date_booking_made) > 10

This sorts out the problem without having to seperate it into two different fields

Date	Title
11/12/2007	Setup PHP SSH2 Connection from php to remote box on pair networks 1. Download modules http://www.php.net/download
20/02/2006	Serialised Array Walk This is an array_walk style serialize that works
February 2006	PHP AddSlashes to an Array Say you have a $_POST array and and you don't know
04/01/2006	MYSQL Select time from a date Consider you have a date field in mysql of format