1481174003 :CONVERT(IF(LENGTH(payTime) = 10,payTime,UNIX_TIMESTAMP(payTime)),SIGNED) YYYY-MM-DD HH:MM:SS : IF(LENGTH(payTime) = 10,FROM_UNIXTIME(CONVERT(payTime,SIGNED)),payTime)