Date Time. How to determine that the date is greater and the time is less?

Question

MySQL

There is a column of type DATETIME. Stores the date and time in the form yyyy-MM-dd HH:mm:ss
Is it possible to do the following without dividing the time and date into separate columns:
display those rows where the date is greater than 2015-09-22 and the time is less than 15:00: 00

Answer 1

SELECT *
FROM table
WHERE
DATE_FORMAT(datefield, '%Y-%m-%d') > '2015-09-22' AND
DATE_FORMAT(datefield, '%H:%i:%s') < '15:00:00'

Answer 2

Look at mysql cast