I want to compare two timestamps (which are in the format of:YYYY-MM-DD HH:MM:SS.SSSSSS example: 2018-07-11 06:38:32.916000) to return all the entries where the tim difference between the two is more than a second.
Here is what I tried:
$where = new Zend\Db\Sql\Where();
//UPDATE and BIRTH are both timestamps
$where->greaterThan(‘UPDATE - BIRTH’, 1);
Yeah… that didnt work. What would be the way to go about this?