0
How to retrieve record by date and time
2 odpowiedzi
0
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)
- 1
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.