摘要：
//$str='1342367999';//$str1='1340985540';//$time=date("Y-m-d H:i:s");//$t1=date("Y-m-d H:i:s",$str1);//echo $t1.'<br>';//echo strtotime($time).'<br>';//$newtime=strtotime($time);//echo date("Y-m-d H:i:s",$newtime); 阅读全文
摘要：
UPDATE item SET DATETIME= DATE_FORMAT('2012-07-15 16:28:58','%Y-%m-%d %H:%i:%s')SELECT * FROM item WHERE DATETIME>NOW()SELECT FROM_UNIXTIME( 1340985540, '%Y%m%d %H%i%s' ) ;SELECT UNIX_TIMESTAMP('2012-06-29 23:59:00') ; 阅读全文