Changing the connection timezone in MySQL

My server is running in MDT

So I used following one to convert EST

SET  time_zone = '-5:00'

But, how can I switch it to EDT because

While `EST` is only valid in winter, while in summer how to change it to `EDT`

I just try to used named time zone. But I am getting following error

 #1298 - Unknown or incorrect time zone: 'America/Toronto'

I don’t understand how to solve this problem

How can i switch

UTC -05 TO UTC-04

Answer

Since you’re using Windows, your going to have to import the time zone description tables to your MySQL server.

http://dev.mysql.com/downloads/timezones.html