I am trying to get the data of the current date in MySQL. I have a column named created_at
which stores the date and time (2017-12-31 11:32:54)
using the NOW()
function using the statements,
$stmt = $this->conn->prepare("INSERT INTO log(id, name, created_at) VALUES(?, ?, NOW())");
$stmt->bind_param("ss", $id, $name);
$result = $stmt->execute();
Now I want to ignore the time in the created_at
column and retrieve the data of the current date (today's date).
I tried using this query,
SELECT * FROM log WHERE created_at = DATE_SUB(CURDATE(), INTERVAL 0 DAY)
But this results in zero rows selected
.
Please help me solve this issue.