Jack:取数据库的毫秒时间
SELECT SUBSTRING(DATE_FORMAT(NOW(6), ‘%m%d%H%i%s%f’),1,22) time;
SELECT DATE_FORMAT(NOW(6), ‘%m%d%H%i%s%f’) time;
Jack: 截取字符串关键字left
left(DATE_FORMAT(NOW(6), ‘%m%d%H%i%s%f’)
Jack:取数据库的毫秒时间
SELECT SUBSTRING(DATE_FORMAT(NOW(6), ‘%m%d%H%i%s%f’),1,22) time;
SELECT DATE_FORMAT(NOW(6), ‘%m%d%H%i%s%f’) time;
Jack: 截取字符串关键字left
left(DATE_FORMAT(NOW(6), ‘%m%d%H%i%s%f’)