rgb192
asked on
unix timestamp is hardcoded in my table but appears different on different host (timezones)
old code, will update soon because does not use pdo, mysqli
code uses mysql
$qfetch='SELECT * from email_doc';
$fetch=mysql_query($qfetch );
while ( $row = mysql_fetch_object( $fetch ) );
echo ' '.date("D", $row->real_timestamp);
echo'<br>'.date("M j, g:i A", $row->real_timestamp);
this is unix_timestamp which is unix_timestamp with an hour added
1379358861
1379359341
1379362620
1379445757
1379446700
1379448620
1379492114
these values are different on different servers. Is there a way to set timestamp
I created another column and I need to add 4-6 hours depending upon which server I am hosting information even though value is hardcoded in datebase table.
code uses mysql
$qfetch='SELECT * from email_doc';
$fetch=mysql_query($qfetch
while ( $row = mysql_fetch_object( $fetch ) );
echo ' '.date("D", $row->real_timestamp);
echo'<br>'.date("M j, g:i A", $row->real_timestamp);
this is unix_timestamp which is unix_timestamp with an hour added
1379358861
1379359341
1379362620
1379445757
1379446700
1379448620
1379492114
these values are different on different servers. Is there a way to set timestamp
I created another column and I need to add 4-6 hours depending upon which server I am hosting information even though value is hardcoded in datebase table.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER