按时间查询数据（时间存储的格式是unix时间戳） 无 SELECT *FROM `pre_common_member_log_w`WHERE DATE_FORMAT( FROM_UNIXTIME( dateline ) , ‘%Y-%m-%d’ ) = DATE_FORMAT( NOW( ) , ‘%Y-%m-%d’ )LIMIT 0 , 30SELECT *FROM `pre_common_member_log_w`WHERE DA

按时间查询数据（时间存储的格式是unix时间戳）

.CodeEntity .code_pieces ul.piece_anchor{width:25px;position:absolute;top:25px;left:-30px;z-index:1000;}
.CodeEntity .code_pieces ul.piece_anchor li{width:25px;background: #efe;margin-bottom:2px;}
.CodeEntity .code_pieces ul.piece_anchor li{border-left:3px #40AA63 solid;border-right:3px #efe solid;}
.CodeEntity .code_pieces ul.piece_anchor li:hover{border-right:3px #40AA63 solid;border-left:3px #efe solid;}
.CodeEntity .code_pieces ul.piece_anchor li a{color: #333;padding: 3px 10px;}
.CodeEntity .code_pieces .jump_to_code{visibility:hidden;position:relative;}
.CodeEntity .code_pieces .code_piece:hover .jump_to_code{visibility:visible;}
.CodeEntity .code_pieces .code_piece:hover .jump_to_code a{text-decoration:none;}
.CodeEntity .code_pieces h2 i{float:right;font-style:normal;font-weight:normal;}
.CodeEntity .code_pieces h2 i a{font-size:9pt;background: #FFFFFF;color:#00A;padding: 2px 5px;text-decoration:none;}

<!–

    –>
    <!–

  • $velocityCount

    • –>
    <!–

–>

SELECT *
FROM `pre_common_member_log_w`
WHERE DATE_FORMAT( FROM_UNIXTIME( dateline ) , '%Y-%m-%d' ) = DATE_FORMAT( NOW( ) , '%Y-%m-%d' )
LIMIT 0 , 30

SELECT *
FROM `pre_common_member_log_w`
WHERE DATE_FORMAT( FROM_UNIXTIME( dateline ) , '%Y-%m-%d' ) = '2014-10-23'
LIMIT 0 , 30



SELECT DATE_FORMAT( FROM_UNIXTIME( dateline ) , '%Y-%m-%d' ) AS mytime, title
FROM `pre_common_member_log_w`
WHERE DATE_FORMAT( FROM_UNIXTIME( dateline ) , '%Y-%m-%d' ) = '2014-10-23'
LIMIT 0 , 30

登录后复制