CDT does not exist in MySQL Timezones
<p>I have recently updated MySql with Timezone information, using information mentioned here <a href="http://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html</a></p>

<p>The problem I am facing is that even though the database now has information on a lot of TimeZones, <code>CDT</code> is not one of them, and when I do a timezone conversion </p>

<p>using 
<code>SELECT CONVERT_TZ(displaytime,'GMT','CDT');</code> it returns null</p>

<p>Other conversions work though like 
<code>SELECT CONVERT_TZ(displaytime,'GMT','MET');</code> works well</p>

<p>I have checked that the timezone table does not contain information about CDT. But I am not sure how to fix it. Should I add this manually to the table? Should I use a different source to import timezone information?</p>