常用SQL函数

SELECT TO_CHAR(TO_DATE(SUBSTR(T.CREATE_TIME, 1, 8),'YYYYMMDD'),'YYYY-MM-DD') 日期,
       DECODE(T.USER_SOURCE, '010', 'pc', '020','app','030','wap') 站点,
  count(DISTINCT ORDER_NO),
       SUM(T.ORDER_MONEY) 
  FROM  T
  LEFT   T1
    ON T.PACKAGE_NO = T1.PACKAGE_NO
 WHERE T.CREATE_TIME >= '20160502'
   AND T.CREATE_TIME < '20160509'
   AND T.ORDER_STAT IN ('020', '050') 
 GROUP BY TO_CHAR(TO_DATE(SUBSTR(T.CREATE_TIME, 1, 8),'YYYYMMDD'),'YYYY-MM-DD'),
          DECODE(T.USER_SOURCE, '010', 'pc', '020','app','030','wap')