public function toSql($fieldName)
{
switch ($this->betweenMode) {
case Between::EXCLUSIVE:
return '(' . $fieldName . ' > ? AND ' . $fieldName . ' < ?)';
case Between::LEFT_EXCLUSIVE:
return '(' . $fieldName . ' > ? AND ' . $fieldName . ' <= ?)';
case Between::RIGHT_EXCLUSIVE:
return '(' . $fieldName . ' >= ? AND ' . $fieldName . ' < ?)';
}
return '(' . $fieldName . ' >= ? AND ' . $fieldName . ' <= ?)';
}