DateRange

Pair framework: DateRange

Pair\Helpers\DateRange is an immutable value object for date-time intervals.

Main methods

• contains(DateTimeInterface $dt): bool
• overlaps(DateRange $other): bool
• intersection(DateRange $other): ?DateRange
• expand(?DateInterval $before = null, ?DateInterval $after = null): DateRange
• shift(DateInterval $delta): DateRange, shiftBy(string $modifier): DateRange
• forMonth(), previousMonth(), nextMonth()
• toArray(string $format = 'Y-m-d H:i:s'): array
• toSqlParams(...): array, toSqlWhere(string $column, ...): string
• toPeriod(DateInterval $step, int $options = 0): DatePeriod

Implementation example

$range = new \Pair\Helpers\DateRange(
    new DateTimeImmutable('2026-02-01 00:00:00'),
    new DateTimeImmutable('2026-02-29 23:59:59')
);

$where = $range->toSqlWhere('createdAt');
$params = $range->toSqlParams(':start', ':end');

$orders = \Pair\Core\Query::table('orders')
    ->whereRaw($where, $params)
    ->get();

Notes

• Constructor validates start <= end.
• Supports month helpers and localization-aware formatting methods.

See also: Query, QueryFilter.