How to convert timezone in MySQL using the timezone name?
To answer the question: 


  Is there any way to convert timezone using timezone name not from timezone offset


The function CONVERT_TZ has this example and warning:

mysql&gt; SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET');
    -&gt; '2004-01-01 13:00:00'



  Note
  To use named time zones such as 'MET' or 'Europe/Moscow', the time zone tables must be properly set up. See Section 10.6, “MySQL Server Time Zone Support”, for instructions.


And the section on Time Zone support has a 'Populating the Time Zone Tables' section which describes the process of setting up the mysql timezone tables.