How to get the time from UNIX time in GMT to IST in the format ‘2013-09-24 19:16:42’? September 24, 2013MySQL Queries, UncategorizedMySQL QueriesWhiteWind SELECT CONVERT_TZ(FROM_UNIXTIME(1380011215),’+05:30′,’+00:00′); o/p 2013-09-24 08:26:55 Share this:Click to share on WhatsApp (Opens in new window)Click to share on Telegram (Opens in new window)Click to share on Twitter (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Tumblr (Opens in new window)Click to share on Pocket (Opens in new window)Click to share on Reddit (Opens in new window)Click to email a link to a friend (Opens in new window)Click to print (Opens in new window)Like this:Like Loading... Related