Hi i have doubt regarding how i can exact match my
timestamp with my
date i'm getting
date from my
URL query string which looks like this
2017-07-19 and my stored
date in my
0 results despite i have this
date in my db
"SELECT all_data where created_at = DATE('2017-07-19')"; // db=> 2017-07-19 13:40:23
Question: how can i exactly match my
2017-07-19 with my
right now i'm getting
please help thanks in advance!!!!
Your query is incorrect (strange that it din't raise any error to you).Need to be like this:-
SELECT * FROM `<table name>` WHERE DATE(created_at) = '2017-07-19'
Note:- put correct table-name there and check.