mysql查詢大于某個(gè)日期 mysql數(shù)據(jù)庫怎么查詢當(dāng)前時(shí)間戳前兩天的數(shù)據(jù)?
mysql數(shù)據(jù)庫怎么查詢當(dāng)前時(shí)間戳前兩天的數(shù)據(jù)?mysql數(shù)據(jù)庫怎么查詢當(dāng)前時(shí)間戳前兩天的數(shù)據(jù)-- 2015年1月份到現(xiàn)在的的數(shù)據(jù)select *,now() as time_now from tim
mysql數(shù)據(jù)庫怎么查詢當(dāng)前時(shí)間戳前兩天的數(shù)據(jù)?
mysql數(shù)據(jù)庫怎么查詢當(dāng)前時(shí)間戳前兩天的數(shù)據(jù)
-- 2015年1月份到現(xiàn)在的的數(shù)據(jù)
select *,now() as time_now from timestampTest
where tmStmp between "2015-01-01 00:00:00"
and now()