'How convert from timestamp from SQL data to EST timezone
As you can see '. date('M-d-Y h:i:s A', strtotime($row['email_open_datetime'])) .'
I would like to make simple convert from timestamp to EST time zone. Right now, i belive timestamp based on UTC from SQL server. I did look all over place and couldn't find what Im looking for. Please help! :(
if($total_row > 0) {
foreach($result as $row) {
$status = '';
if($row['email_status'] == 'yes') {
$status = '<span class="label label-success">Open</span>';
}else{
$status = '<span class="label label-danger">Not Open</span>';
}
$output .= '
<tr>
<td>'.$row["email_address"].'</td>
<td>'.$row["email_subject"].'</td>
<td>'.$status.'</td>
<td>'. date('M-d-Y h:i:s A', strtotime($row['email_open_datetime'])) .'</td>
</tr>';
}
} else {
$output .= '
<tr>
<td colspan="4" align="center">No Email Send Data Found</td>
</tr>';
}
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
