SELECT THK_GRP_CD,MINI,MAXI,TO_CHAR(TO_DATE(REG_DTIME,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS') REG_DTIME, REG_ID,TO_CHAR(TO_DATE(MOD_DTIME,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS') MOD_DTIME,MOD_ID,TYPE_ FROM TBF02_ROLL_THK_GRP WHERE PLT='C' SELECT WTH_GRP_CD,MINI,MAXI,TO_CHAR(TO_DATE(REG_DTIME,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS') REG_DTIME, REG_ID,TO_CHAR(TO_DATE(MOD_DTIME,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS') MOD_DTIME,MOD_ID FROM TBF02_ROLL_WTH_GRP A WHERE A.PLT='C'