BLADE {{ \Carbon\Carbon::parse($data->created_at)->setTimezone('Asia/Dhaka')->format('d M Y - h:i A') }} CONTROLLER use Carbon\Carbon; use Illuminate\Support\Facades\DB; $data['orders'] = FoodOrder::whereDate(DB::raw("CONVERT_TZ(created_at, '+00:00', '+06:00')"), Carbon::today('Asia/Dhaka'))->get();