Yii syntax for PGSQL date INTERVAL function

I am locked with how to fill the following code

$criteria->addSearchCondition('esdate', 'now()-interval \'1 day\'', false, 'AND', '>');

if I use 'now()' alone it could work but as soon as I add the interval function I cannot get it done. I guess the escaped quote may not be accepted, but was unable to find any correct syntax.

Any help more than appreciated...

Answers


$criteria->addCondition( "esdate > NOW() - INTERVAL 1 DAY" );

Need Your Help

How to create a loading window while I query a MSSQL server using VB.NET?

sql-server vb.net winforms

I hope you can help me on this. I need to implement a loading window or loading bar while I'm running a query to a MSSQL database using VB.NET. My goal is to avoid my program to hang while the scri...

PDO Query Database ODBC

php ms-access pdo odbc

I'm on my way learning about PDO from phpro.org, and a little bit confuse.