Conversion of Oracle TO_CHAR(datetime) with format string to MysqL

The Oracle TO_CHAR(datetime,fmt) function converts datetime values to a string in the format specified by the fmt option.

MysqL has the DATE_FORMAT function that allows datetime values converting to a string in the specified format.

sqlWays converts the Oracle TO_CHAR function to the MysqL DATE_FORMAT function and converts elements of format string from Oracle to corresponding specifier in MysqL as specified in the following table

create procedure sp_to_char_date_format
as
begin
-- GET ACTUAL TIME AND DATE
select to_char(sysdate,'DD-MON-YYYY:HH24:MI') 
from dual;
end; 

create procedure sp_to_char_date_format()
begin
-- GET ACTUAL TIME AND DATE
select  DATE_FORMAT(CURRENT_TIMESTAMP,'%e-%M-
%Y:%H:%i')  from dual;
end;