UNIX_TIMESTAMP(date):获取时间戳SELECT UNIX_TIMESTAMP() SELECT UNIX_TIMESTAMP(‘2016-01-16') SELECT UNIX_TIMESTAMP(‘2016-01-16 23:59:59')登录后复制-> 1452937627 -> 1452873600 -> 1452959999登录后复制