title: how to fetch datetime along with GMT appended with it in mysql?
body: <p>I was looking for "how to fetch datetime along with UTC appended with it" in mysql. but i dont find any proper solution in stackoverflow.</p>
  
  <p>Many suggested to convert datetime to required utc within query itself by assigning default_time_zone but i want to convert the datetime at user end depends on their system settings.</p>
  
  <p>I have a field called "<strong>created_on TIMESTAMP DEFAULT CURRENT_TIMESTAMP</strong>" </p>
  
  <p>whenever i fetch data, i am getting date as "<strong>yyyy-mm-dd hh:mm:ss</strong>" (ex. <em>2015-04-01 11:30:25</em>)</p>
  
  <p>but the format i want is "<strong>2015-04-01 11:30:25 +5:30</strong>" where (<strong>+5:30</strong> is default_time_zone of the server) so that i can convert it at user end as "<strong>2015-04-01 10:30:25</strong>" (assuming user's timezone is <strong>+4:30</strong>)</p>
  
  <p>so my question is <strong>how to fetch datetime along with UTC appended with it in mysql so that i can convert it at user end depend on their system settings?</strong></p>