public function changeSortType($field, $type) { $type = trim($type); switch (strtoupper($type)) { case 'TVDATETIME': $field = "STR_TO_DATE(" . $field . ",'%d-%m-%Y %H:%i:%s')"; break; default: $field = parent::changeSortType($field, $type); } return $field; }