SELECT TO_CHAR(日付日時型日付編集,'YYYYMMDD HHMISS') FROM SAM_TEST;

SELECT TO_CHAR(日付日時型年月編集,'YYYYMMDD HHMISS') FROM SAM_TEST;

UPDATE SAM_TEST SET 日付日時型日付編集=TO_DATE(200501101100,'yyyymmddhhmi');

UPDATE SAM_TEST SET 日付日時型年月編集=TO_DATE(200501011215,'yyyymmddhhmi');

(