CoderZone.org

Category: >> mySQL >> MYSQL Select time from a date Bookmark and Share

<< lastnext >>

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)

Author: CoderZone
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
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 42