Datatables Editor Timestamp Where Clause

Question

I am working with DataTables Editor trying the populate a grid with events from a database which have occurred on the current day. I have tried the following query however come across a problem:

// Time
$date = date_create();
$date = date('m/d/Y', date_timestamp_get($date));
// Where Clause
if (isset($_GET['gridNumber']) && $_GET['gridNumber']==2 && isset($_GET['varTodaysActions']) && $_GET['varTodaysActions']=='y') {
    $editor->where($key = date('m/d/Y', strtotime('tblActions.actionTimeStamp')), $value = $date, $op = '=' );
}

The issue seems to be comparing formatted unixtime stamps from the database with the current date. The error I receive is

{"error":"SQLSTATE[42S22]: Column not found: 1054 Unknown column '12/31/1969' in 'where clause'","data":[]}

Answer 1

The $key parameter should be a

Single field name, or an array of field names

(see Editor API)

This is used as a column name, which obviously does not exist, hence the sql error. Perhaps you can apply the formatting to $date variable.