Wednesday, January 17, 2018

ORACLE - How convert (current) datetime to formated string

select to_char( sysdate, 'dd.mm.yyyy hh24:mi' ) from dual;
Output:
TO_CHAR(SYSDATE,
----------------
17.01.2018 13:26

No comments:

Post a Comment