[ORACLE] 날짜변환

select to_char('2018-10-04 12:00:00.0','YYYYMMDD')

 from dual

;

SELECT TO_CHAR(SYSDATE, 'YYYY-MM-DD hh24:mi:ss.ff') FROM DUAL;

SELECT TO_CHAR(current_

--2016-09-16 00:00:00.0

SELECT TO_DATE(DECODE(C.SOUT_GF_ARRIVAL_DATE,NULL,NVL( B.PODI_REPORTING_DATE,TO_CHAR(SYSDATE,'YYYYMMDD')),C.SOUT_GF_ARRIVAL_DATE),'YYYYMMDD') AS TRUCK_REPORTING_DATE 

;

SELECT TO_DATE(SYSDATE,'YYYYMMDD') ;

SELECT to_char( TO_TIMESTAMP('2018-10-04 12:00:00.0'),'YYYYMMDDhh24miss' ) FROM DUAL;

-- 20181004120000

select to_date( to_char( TO_TIMESTAMP('2018-10-04 12:00:00.0'),'YYYYMMDDhh24miss' ), 'YYYYMMDDhh24miss' )

 from dual

;

-- 2018/10/04 12:00:00

select to_date( to_char( TO_TIMESTAMP('2016-09-16 00:00:00.0'),'YYYYMMDDhh24miss' ), 'YYYYMMDDhh24miss' )

 from dual

;

-- 2016/09/16 00:00:00