In my table, I have a field called created_at with data type timestamp and values are like 2016-12-30 00:30:10 and so on.
In my query, I get all those by a simple select * statement.
How can I get only the dates where it is equal to today's date?
I am using a framework called makoframework and the query builder is this:
$data = $query->table('customers')
->where('created_at', '=', //date today)
->all();
Any help would be much appreciated.
This will work
WHERE DATE(created_at) = CURDATE()
Try
->where('DATE(created_at)', '=', '2016-12-30')
I'm sure about the query but I haven't used that framework so i'm not sure if it will pass it over to mysql as it is.
Use this for your framework
->whereRaw('DATE(created_at)', '=', '2016-12-30')
I don't know which framework you are using but in Core PHP you can use date() function to print the current date in a specific format.
$data = $query->table('customers')
->where('DATE(created_at)', '=', date('Y-m-d'))
->all();
So I opened an issue in the framework's github site and the correct way to which is working is this:
$now = date('Y-m-d');
->where(new Raw('Date(ph.created_at)'), '=', $now)
Just remember to import mako\database\query\Raw
Thanks for all the help.