public static daysAsSql ( integer | string | DateTime $begin, integer | string | DateTime $end, string $fieldName, string | DateTimeZone | null $timezone = null ) : string | ||
$begin | integer | string | DateTime | UNIX timestamp, strtotime() valid string or DateTime object |
$end | integer | string | DateTime | UNIX timestamp, strtotime() valid string or DateTime object |
$fieldName | string | Name of database field to compare with |
$timezone | string | DateTimeZone | null | Timezone string or DateTimeZone object |
return | string | Partial SQL string. |
public static function daysAsSql($begin, $end, $fieldName, $timezone = null)
{
$begin = new DateTime($begin, $timezone);
$begin = $begin->format('U');
$end = new DateTime($end, $timezone);
$end = $end->format('U');
$begin = date('Y-m-d', $begin) . ' 00:00:00';
$end = date('Y-m-d', $end) . ' 23:59:59';
return "({$fieldName} >= '{$begin}') AND ({$fieldName} <= '{$end}')";
}