Insert date in DD MM YY format in php myadmin : <p>I want to insert date in dd mm yy format and this is my php script</p>

<pre><code>date_default_timezone_set('Asia/Kolkata');

            $date = date('Y-m-d');

            $qry="INSERT INTO `nesbaty_offer`( `provider_id`, 
                                   `offer_punch`, 
                                   `offer_description`, 
                                   `terms`, 
                                   `sales_discount`, 
                                   `referal`, 
                                   `duration`, 
                                   `billing_type`, 
                                   `status`, 
                                   `service_location`, 
                                   `time`) VALUES('".$provider_id."',
                                   '".$offer_punch."',
                                   '".$offer_description."',
                                   '".$terms."',
                                   '".$sales_discount."',
                                   '".$referral."',
                                   '".$duration."',
                                   '".$billing_type."',
                                   '".$status."',
                                   '".$service_location."',
                                   '".$date."')";
</code></pre>

<p>Currently it is storing like this </p>

<pre><code>YY-MM-DD
2018-05-22
</code></pre>

<p>But i want this </p>

<pre><code>22-05-2018
</code></pre>

<p>Is it possible?</p>
