0

How to retrieve record by date and time

11th May 2017, 5:19 PM
Karthik Raja
Karthik Raja - avatar
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)
16th May 2017, 6:30 AM
Logan Canter
Logan Canter - avatar
- 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.
12th May 2017, 5:29 AM
Álvaro