{"version":"1.0","provider_name":"InMotion Hosting Support Center","provider_url":"https:\/\/www.inmotionhosting.com\/support","author_name":"InMotion Hosting Contributor","author_url":"https:\/\/www.inmotionhosting.com\/support\/author\/inmotion-hosting-contributor\/","title":"How to convert MySQL time | InMotion Hosting","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"GxyKbPNQVk\"><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-convert-mysql-time\/\">How to convert MySQL time<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-convert-mysql-time\/embed\/#?secret=GxyKbPNQVk\" width=\"600\" height=\"338\" title=\"&#8220;How to convert MySQL time&#8221; &#8212; InMotion Hosting Support Center\" data-secret=\"GxyKbPNQVk\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/www.inmotionhosting.com\/support\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","description":"In this article we'll discuss the ability you have within MySQL to convert time storage such as time stamps and time zones to better meet your local needs. In many cases you might need to convert the server's time stamp to your own local time zone so you can more easily go through the data.","thumbnail_url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/11\/website_cpanel_cpanel-split_cpanel-click-on-phpmyadmin.png"}