oracle中日期的格式化

最新推荐文章于 2024-06-28 08:00:00 发布

suoyasong

最新推荐文章于 2024-06-28 08:00:00 发布

阅读量1.6k

点赞数

本文链接：https://blog.csdn.net/suoyasong/article/details/82667275

版权

SELECT channel.CHAN_NM AS CHAN_NM,channel.CHAN_CD AS CHAN_CD,channel.CHAN_DES_WATER_H AS DES_WATER_H,
st.STNM, st.MONITOR_TYPE AS MONITOR_TYPE,
water.TM,water.STCD,  dict.LABEL AS MONITOR_TYPE_NAME,
waterDay.PERIOD_TOTAL AS DAY_TOTAL,waterMonth.PERIOD_TOTAL AS MONTH_TOTAL,waterYear.PERIOD_TOTAL AS YEAR_TOTAL
FROM CHANNEL_ST st
LEFT JOIN CHANNEL channel ON channel.CHAN_CD = st.CHAN_CD
LEFT JOIN CHANNEL_WATER_CUR water on st.STCD = water.STCD
--LEFT JOIN WP_CHANNEL_DAY day ON day.STCD = st.STCD AND CONCAT(to_char(water.TM,'yyyy-mm-dd'), ' 00:00:00') = to_char(day.STATI_TM,'yyyy-mm-dd hh24:mi:ss')
LEFT JOIN WP_CHANNEL_DAY waterDay ON waterDay.STCD = st.STCD AND to_date(to_char(water.TM,'yyyy-mm-dd'),'yyyy-mm-dd hh24:mi:ss') = waterDay.STATI_TM
LEFT JOIN WP_CHANNEL_MONTH waterMonth ON waterMonth.STCD = st.STCD AND CONCAT(to_char(water.TM,'yyyy-mm'), '-01 00:00:00') = to_char(waterMonth.STATI_TM,'yyyy-mm-dd hh24:mi:ss')
LEFT JOIN WP_CHANNEL_YEAR waterYear ON waterYear.STCD = st.STCD AND CONCAT(to_char(water.TM,'yyyy'),'-01-01 00:00:00') = to_char(waterYear.STATI_TM,'yyyy-mm-dd hh24:mi:ss')
LEFT JOIN SYS_DICT dict ON dict.VAL = st.MONITOR_TYPE AND dict.TYPE_ID = 8
LEFT JOIN  SYS_MG_ORG org  ON org.MNG_ORG_CD = channel.MNG_ORG_CD