$sth = $dbh->prepare <<EOSQL;
    select
        DATE_FORMAT(The_Date_Col, '%d/%m/%Y')
    from the_table
    where
        Some_key = ?
EOSQL