摘要:
SELECT head.fcust_party_id,count(1) FROM 表名 head WHERE to_date(substr(head.fcreate_date,1,10),'yyyy-mm-dd') >=to_date('2017-01-01','yyyy-mm-dd') group 阅读全文
摘要:
function getShorMonths(){ var d = new Date(); var str = d.getFullYear()+"-"+(d.getMonth()+1); var arr=["2018-12","2018-11","2018-10","2018-09","2018-0 阅读全文
摘要:
WITH temp0 AS (SELECT LEVEL lv FROM dual CONNECT BY LEVEL <= 100) SELECT MAX(REPLACE(sys_connect_by_path(str, ' '), ' ', '')) f1 FROM (SELECT str, row 阅读全文
摘要:
//时间转换function resultFormat(s) { var t="通话时长 "; if(s > -1){ var hour = Math.floor(s/3600); var min = Math.floor(s/60) % 60; var sec = s % 60; if(hour> 阅读全文
摘要:
function formatDateTime(inputTime) { var date = new Date(inputTime); var y = date.getFullYear(); var m = date.getMonth() + 1; m = m < 10 ? ('0' + m) : 阅读全文