Code Example Center: ORACLE - How convert (current) datetime to formated string

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

Subscribe to: Post Comments (Atom)