You can use a string in place of a query:
db("Start_date < NOW()").select(db.tbl.ALL)
On Sunday, 16 September 2012 13:42:38 UTC-5, MichaelF wrote:
>
> Is there a way I can use 'arbitrary' SQL functions in my queries? For
> example, I might want to do something akin to:
>
> SELECT * FROM tbl WHERE Start_date < NOW();
>
> I realize that in this particular case I can translate the "NOW()" SQL
> function to the current date/time. But how about other functions? If I use
> them am I limited to using executesql?
>
> Thanks.
>
--
