I'm restructuring my MySQL database, which has several columns in Unix format.
Because I already have several rows in the database in Unix format. How can I convert the Unix fields to iso, and then subtract an hour using PHP?
For example, I currently have:
<?php
$unix_time = 1267840开发者_运维问答800;
$conversion = date("c", $unix_time);
The above code spits out:
2010-03-05T20:00:00-06:00
My question is, how can I take it a step further and subtract an hour and just have:
2010-03-05 19:00:00
<?php
$unix_time = 1267840800;
$one_hour = 60 * 60;
$conversion = date("Y-m-d h:i:s", $unix_time - $one_hour);
You could also take your timestamp and say strtotime("-1 hour", 1267840800).
精彩评论