无法获取当前时间戳

Question

Need help getting pulling timestamp from database. timestamp = CURRENT_TIMESTAMP I need it to show our current timezone EST time. Need help doing this.

current query

    mysql_select_db($database_localhost, $localhost);
$query_leadsscott = "SELECT * FROM leads WHERE marketer = 'scott' ORDER BY `timestamp` DESC";
$leadsscott = mysql_query($query_leadsscott, $localhost) or die(mysql_error());
$row_leadsscott = mysql_fetch_assoc($leadsscott);
$totalRows_leadsscott = mysql_num_rows($leadsscott);` 



' <h6>Marketing Reports for Emily</h6>
    <table border="1">
      <tr>
        <td>Timestamp</td>
        <td>Marketer</td>
        <td>Facility</td>
        <td>Name</td>
        <td>Type</td>
        <td>Description</td>
        <td>Cocality</td>
        <td>State</td>
        <td>Zip</td>
        <td>Latlng</td>
      </tr>
      <?php do { ?>
        <tr>
          <td><?php echo $row_leadsemily['timestamp']; ?></td>
          <td><?php echo $row_leadsemily['marketer']; ?></td>
          <td><?php echo $row_leadsemily['facility']; ?></td>
          <td><?php echo $row_leadsemily['name']; ?></td>
          <td><?php echo $row_leadsemily['type']; ?></td>
          <td><?php echo $row_leadsemily['description']; ?></td>
          <td><?php echo $row_leadsemily['locality']; ?></td>
          <td><?php echo $row_leadsemily['state']; ?></td>
          <td><?php echo $row_leadsemily['zip']; ?></td>
          <td><a href="https://www.google.com/maps/place/<?php echo $row_leadsemily['latlng']; ?>"> Link </a></td>
        </tr>
        <?php } while ($row_leadsemily = mysql_fetch_assoc($leadsemily)); ?>
    </table>'   

Timestamp that shows back on report time as follows

Timestamp
2016-05-09 13:16:57

I need this to show EST it is currently showing UTC time

Answer 1

If the offset is always the same you can just modify your output and leave the timestamp in the db as UTC:

 DATE_ADD(timestamp, INTERVAL 2 HOUR)