Relative Content

Tag Archive for phplaravelpostgresqldate

Laravel date->format is not working at whereDate()

$period = new DatePeriod( new DateTime( ‘2024-03-20 00:00:00’ ), new DateInterval(‘P1D’), new DateTime( ‘2024-03-28 23:59:59’ ) ); $orders = OrderProduct::where (‘brand’,'<>’,’NULL’); foreach ($period as $date){ $labels[] = $date->format(‘d-m-Y’); $searchDate = $date->format(‘Y-m-d’); **//This doesn’t work** //$searchDate = ‘2024-03-26’; **//This works** $order = $orders->whereDate( ‘updated_at’,’=’,$searchDate )->get(); foreach ($order as $item){ if( $item ){ Log::info( $item->brand ); } […]