ORM for mysql now () - Laravel 4

Question

I have the following sql

select * from bids where deleted_at is  null 
and  publication_date <= now() and open_date >= now()

I want to write it using ORM

   $bids = Bid::where('publication_date','<=','now()')->where('open_date','>=','now()')->get();

It doesn't work then I rewrite as below

$bids=DB::select(DB::raw('select * from bids where deleted_at is  null and  publication_date <= now() and open_date >= now()'));

How to write above ORM query, I think that now()

poses the problem

+3

sumit 04 Aug 14 at 10:05

1 answer

Thorsten · Accepted Answer · 2014-08-04T10:17:38+0000

You can use the method whereRaw

:

$bids = Bid::whereRaw('publication_date <= now() and open_date >= now()')->get();