How to set Asia/Kuala_Lumpur timezone while updating CURTIME and CURDATE
<p>While updating <code>CURDATE()</code> and <code>CURTIME()</code> into a column, it updates wrong time and date. I want to change the existing Timezone into <code>Asia/Kuala_Lumpur</code></p>

<p>here is my update script:</p>

<pre><code>$sql="UPDATE smss SET msg='$msg', r_date=CURDATE(), r_time=CURTIME(), phone='$phone' WHERE p_n='$p_n' and (p_n=null or p_n='') and (phone=null or phone='')";
</code></pre>