my (
        $dev,  $ino,   $mode,  $nlink, $uid,     $gid, $rdev,
        $size, $atime, $mtime, $ctime, $blksize, $blocks
    ) = stat($file);

    my ( $sec, $min, $hour, $mday, $mon, $year, $wday, $yday, $isdst ) =
      localtime($mtime);

    # make a MySQL compatible date
    my $mysqlDate = strftime(
        "%F %T", $sec,  $min,  $hour, $mday,
        $mon,    $year, $wday, $yday, $isdst
    );