Wednesday, January 17, 2018

ORACLE - How to convert string to date (with mask)

select to_char( to_date( '20180105', 'yyyymmdd' ), 'dd.mm.yyyy' ) from dual;
Output:
TO_CHAR(TO
----------
05.01.2018

No comments:

Post a Comment