use DateTime;
use DateTime::Format::Strptime;

my $db_update_time = '2024-04-07 15:03:27';

my $parser = DateTime::Format::Strptime->new(
                pattern   => '%Y-%m-%d %T',
                locale    => 'en_US',
                time_zone => 'Europe/Berlin',
                on_error  => 'croak',
);

my $datetime = $parser->parse_datetime($db_update_time);
$datetime->set_time_zone('Greenwich');
$formatted_time = $datetime->strftime('%Y-%m-%d %T');

print $formatted_time;
#output: 2024-04-07 13:03:27