Get difference between two date type column in a Query

Here is an example of an Eloquent version of what you might be looking for.

It's not clear to me what type of database you're querying, it doesn't look like MySQL syntax, but it also doesn't look like that SQLServer sytax either (but I'm not that familiar with SQLServer...).

No matter, here's an example that works for MySQL, perhaps this will help you:

public function recent() {
    return \DB::table('posts')
        ->selectRaw('*, datediff(created_at, now())')
        ->whereRaw('datediff(created_at, now()) > ?', [-99])
        ->get();
}