Active Directory“whenCreated”到MySQL datetime

Question

Is there a more compact and elegant way to convert Active Directory "whenCreated" values like "20141114120225.0Z" into a MySQL datetime format than the code below?

if(preg_match("/^(....)(..)(..)(..)(..)(..)/", $value, $m))
  $value = sprintf("%s-%s-%s %s:%s:%s", $m[1], $m[2], $m[3], $m[4], $m[5], $m[6]);

Answer 1

Something like that ?

<?php 
    // The regexp ensures only numbers were used
    $valueForMySQL = preg_replace("/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2}).+/","$1-$2-$3 $4:$5:$6", $value);
?>