mysql數(shù)據(jù)庫(kù)怎么查詢當(dāng)前時(shí)間戳前兩天的數(shù)據(jù)？mysql數(shù)據(jù)庫(kù)怎么查詢當(dāng)前時(shí)間戳前兩天的數(shù)據(jù)-- 2015年1月份到現(xiàn)在的的數(shù)據(jù)select *，now() as time_now from tim

mysql數(shù)據(jù)庫(kù)怎么查詢當(dāng)前時(shí)間戳前兩天的數(shù)據(jù)？

mysql數(shù)據(jù)庫(kù)怎么查詢當(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()

mysql怎么查詢當(dāng)天的所有記錄？我存的是時(shí)間戳？

取當(dāng)天0點(diǎn)的時(shí)間戳然后做判斷，獲取時(shí)間戳大于這個(gè)時(shí)間的數(shù)據(jù)0點(diǎn)的時(shí)間戳，可以將自己寫個(gè)正常時(shí)間格式的0點(diǎn)時(shí)間，然后轉(zhuǎn)換成時(shí)間戳就得到了