Spaghetti\XLSXParser\Transformer\Date::transform()

Complexity

Conditions	1
Paths	1

Size

Total Lines	11
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php declare(strict_types = 1);
    public function transform(float|int $value): DateTimeImmutable
    {
        $format = 'd-m-Y H:i:s';
        $base = 25569;

        $value = (int) floor(num: $value);
        /** @noinspection SummerTimeUnsafeTimeManipulationInspection */
        $unix = ($value - $base) * 86400;
        $date = gmdate(format: $format, timestamp: $unix);

        return DateTimeImmutable::createFromFormat(format: '!' . $format, datetime: $date);
    }