Regexp solves everything!

<?php
$time="15/05/24 14:00";
$sql_time=preg_replace('#^(\d+)/(\d+)/(\d+) (.*)$#','20$3-$2-$1 $4:00',$time);
echo $sql_time;

//2024-05-15 14:00:00

https://3v4l.org/nkD4n