How to retrieve record by date and time

Answer 1

SELECT * FROM table
WHERE DATE(datetime) = '00-00-0000'

or

SELECT * FROM table
WHERE datetime LIKE '%00-00-0000%'

(edit: fixed it up a bit

0s are where the date would be, or if you have it set to / instead of - change that)

Answer 2

Do you have some datetime column? Maybe you want to retrieve records that are created/update from a certain datetime? Please further explain your question.