简介

"zj" + year($日期) + if(month($日期) < 10, CONCATENATE("0", month($日期)), month($日期)) + if(day($日期) < 10, CONCATENATE("0", day($日期)), day($日期)) + if(HOUR(NOW()) < 10, CONCATENATE("0", HOUR(NOW())), HOUR(NOW())) + if(MINUTE(NOW()) < 10, CONCATENATE("0", MINUTE(NOW())), MINUTE(NOW())) + if(SECOND(NOW()) < 10, CONCATENATE("0", SECOND(NOW())), SECOND(NOW()))