您可以使用unix_timestamp
以下日期作为日期1970
:
SELECT (unix_timestamp('2013-01-01 10:10:10')
- unix_timestamp('1970-01-01 00:00:00'))/60
添加分钟: change date to unixtime -> add var * 60sec -> convert back to date
SELECT from_unixtime(unix_timestamp('2013-01-01 10:10:10') + 10 * 60) AS result