Is there a way to make DB::table() return Carbon Date

That is possible only with eloquent models ...

thats what i was afraid of. :(

What you can do is fetch the data with DB::table() and then parse it with carbon

use Illuminate\Support\Facades\DB;
use Carbon\Carbon;

$user = DB::table('users')->get()->first();
$date = Carbon::parse($user->created_at);

@ahmeddabak - Or instead of using DB, you could just the the eloquent model to begin with, that way created_at is already casted to Carbon. Why have the model if you're not even going to use it?

There is probably an underlying reason why the OP wants to use the query builder in preference to Eloquent, and why the OP needs the dates as Carbon instances. Maybe, if we knew these reasons, we could better suggest a solution.

Carbon is completely independent of eloquent.

I feel like sometimes i reach the limit of Eloquent and im just better of going DB way. Like doing more complex joins also aliasing tables. Filtering data on joined tables so on.

As my query is behinde a Repository layer i can parse all my data fileds in the all() or paginate() function of my Repo.

Depending on where you want to use the date, you could create a helper function?