數(shù)據(jù)庫時(shí)間戳怎么用 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()