摘要:
function isValidDate(sText) { var reDate = /(?:0[1-9]|[12][0-9]|3[01])\/(?:0[1-9]|1[0-2])\/(?:19|20\d{2})/; return reDate.test(sText); } function vali 阅读全文
摘要:
select count(1),DATE_FORMAT(FROM_UNIXTIME(createtime/1000), '%Y-%m-%d') as time from bskuser where createtime between 1487347200000 and 1488211199000 group by time 阅读全文
摘要:
SELECT (CASE payType WHEN 1 THEN '微信' WHEN 2 THEN '支付宝' ELSE '余额' END) as type, count(payType) FROM order_info WHERE payJe > 0 AND payTime IS NOT NULL 阅读全文