WHEN to_char(BEGIN_TIME5,'yyyyMMdd') <= to_char(sysdate,'yyyyMMdd') AND to_char(OVER_TIME5,'yyyyMMdd') >= to_char(sysdate,'yyyyMMdd') THEN TASK_NAME5 END ) AS taskName, a.PL_PROJECT_MAIN_ID, a.PL_PROJECT_NAME, a.PL_PROJECT_NO, ( CASE WHEN a.PL_PROJECT_ATTRIBUTE = '1' ...
www.dbjr.com.cn/database/330973j...htm 2025-6-9