How can I convert datetime to string in PL SQL?

Question

Is it possible to convert a Datetime value to string in PL SQL? I should to do that to a IF in PL SQL

user_10364858 · Answer

Use to_char(date, format)

e.g.

Select to_char(sysdate,'DD-MON-YYYY') from dual;

user_1332870 · Answer

You can use like this:

SELECT  
TO_CHAR(TO_DATE('20190811 10:44:11','YYYYMMDD HH24:Mi:SS'),'YYYYMMDD HH24:Mi:SS') YOUR_STRING_DATE
 FROM
DUAL