连表查询时间格式转换
SELECT*
FROM IM_BASIC_EQUIPMENT_INFORMATION a,CZ_SAFETY_VALVE_CHECK_UPHOLD b
WHERE a.CODE = b.EQUIPMENT_ID
and a.STATION_ID = 'GE1001050000005566'
SELECT *
FROM SP_PROJECT_MANAGEMENT aa,SP_PM_MODIFY_RECORDS bb
where aa.PROJECT_TYPE = '地灾治理'
and aa.DEL_FLAG = 0
-- and aa.ORG_NAME = '川西北气矿'
and aa.id = bb.PM_ID
and TO_CHAR(bb.REPORT_TIME,'yyyy-MM-dd') >= '2022-12-01'
本文来自博客园,作者:{IceSparks},转载请注明原文链接:https://www.cnblogs.com/IceSparks/p/16803814.html