摘要：
SELECT SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'),1,5) Day, SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'00',1,0)) H00, SU 阅读全文
posted @ 2016-05-23 09:44 徐正柱- 阅读(891) 评论(0) 推荐(0)
|
|||
|
摘要：
SELECT SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'),1,5) Day, SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'00',1,0)) H00, SU 阅读全文
posted @ 2016-05-23 09:44 徐正柱- 阅读(891) 评论(0) 推荐(0) |
||
浙公网安备 33010602011771号