Mysql got the unix time idea and code 60 days ago, mysqlunix

Mysql got the unix time idea and code 60 days ago, mysqlunix

Select UNIX_TIMESTAMP (ADDDATE (NOW (), INTERVAL-60 DAY ))

Obtain the current time based on now ().

Use the adddate () method to obtain the time 60 days ago

Use unix_timestamp () to convert the time type

How can MYSQL determine the data of Fan Wei within a week based on the UNIX timestamp?

Select * from table
Where dateline> (unix_timestamp ()-3600*24*7)

Question about mysql date functions? FROM_UNIXTIME

Why don't you write this?

Select count (*) from pay_payorder where addTime = UNIX_TIMESTAMP ('2017-11-30 ');

These two sentences have the same effect, but the efficiency will be much lower, especially when the data volume is large.