Convert years.months formatted string to months in PHP

Question

Unfortunately, I have data from a client in an unusual format. I expected years and months in separate columns, but instead, it comes as a dot-delimited string: [years].[months].

I have imported this data into MySql Database and now requires to convert years.months to months on which I am going to set some action further.

So I want to convert years (with months after the decimal) to months only in PHP.

Test cases:

• 1.2 (1 year, 2 months) to 14

• 1.0 (1 year, 0 months) to 12

I have written the below code that may be having issues so I want to correct it.

$yearwithdecimal = "1.2";
$yearwithdecimal = (float)$yearwithdecimal;
if (is_float($yearwithdecimal)) {
    $yearsArray = explode(".",$yearwithdecimal);
    $year_months = $yearsArray[0]*12;
    $more_months = $yearsArray[1];
    $total_months = $year_months + $more_months;
}else{
    $total_months = $yearwithdecimal*12;
}
echo $total_months; die;
// Output is 14

Answer 1

Suppose your field the first part represents num of years and the second part represents num of months.

Take the field as a string, then explode it by .

$yearwithdecimal = "1.2";
$months = 0;
if($yearwithdecimal){
    $parts = explode('.', $yearwithdecimal);
    $months = $parts[0]*12 + ($parts[1] ?? 0);
}
echo $months;

Demo: https://3v4l.org/VhOfV

Answer 2

$yearWithDecimal = 1.2;

$years = floor($yearWithDecimal);
$months = ($yearWithDecimal - $years) * 12;

$totalMonths = ($years * 12) + $months;

echo $totalMonths; // Output is 14.4

Answer 3

As demonstrated at PHP Convert Minutes+Seconds to Seconds, parse your formatted/delimited string into integer type variables, then increase the $months value by the $years value times 12.

Code: (Demo)

$tests = ['1.2', '1.0', '2.11'];

foreach ($tests as $test) {
    sscanf($test, '%d.%d', $years, $months);
    $months += $years * 12;
    echo $months . PHP_EOL;
}

Output:

14
12
35

Answer 4

    $yearwithdecimal = "1.2";
$yearwithdecimal = (float)$yearwithdecimal;
if (is_float($yearwithdecimal)) {
    $yearsArray = explode(".",$yearwithdecimal);
    $year_months = $yearsArray[0]*12;

    $more_months = isset($yearsArray[1]) ? $yearsArray[1] : 0; 

     $total_months = $year_months + $more_months;
   }else{
        $total_months = $yearwithdecimal*12;
    }

     echo $total_months;

Answer 5

1. Split the increment value into 2 parts, $incYears and $incMonths
2. Convert the $incYears into months ($incYears * 12) and add the $incMonths
3. Add the month to the date

    function addDecimalYears($fromDate, $increment){
        $segments = explode(".", (string)$increment, 2);
        $incYears = isset($segments[0]) ? $segments[0] : 0;
        $incMonths = isset($segments[1]) ? $segments[1] : 0;

        $months = 12 * (int)$incYears;
        $months += (int)$incMonths;

        $fromDateTimestamp = strtotime($fromDate);
        return date("Y-m-d", strtotime("+" . $months . "month", $fromDateTimestamp));
    }

    echo addDecimalYears("2023-11-02", 1.0) . "\n";
    echo addDecimalYears("2023-11-02", 1.) . "\n";
    echo addDecimalYears("2023-11-02", .12) . "\n";
    echo addDecimalYears("2023-11-02", 1.6) . "\n";
    echo addDecimalYears("2023-11-02", .18) . "\n";
    echo addDecimalYears("2023-11-02", 0.6) . "\n";

Output:

2024-11-02
2024-11-02
2024-11-02
2025-05-02
2025-05-02
2024-05-02