How to get data from database using date?

I want to selecting and showing data based on current date. I have made query selected for this, but it not working

this is my date data on table :

this is my query:

$now = date('Y-m-d');
$trans = FA_transaction::where('assign_date', $now)->get();

when i execute the query, i don't get any data

via Chebli Mohamed