Convert time to a different time zone in mysql
<p>I am saving order details with server time which is "Central Daylight Time" timezone as Unix time stamp. So order_date is the server time. What I need is, convert that to Korean time. Below is the query which I have used.</p>

<pre><code>SELECT 
  `order_date`,
  FROM_UNIXTIME(`order_date`),
  CONVERT_TZ(FROM_UNIXTIME(order_date), 'US/Central', 'Asia/Seoul') 
FROM
  my_orders 
WHERE order_id="123"
</code></pre>

<p>This gives null result for the converted date. Is there anything I have to change with the CONVERT_TZ parameter? Or there is any other better methods for this?</p>