i) to_char(): This function converts the oracle date into character format and the format must be specified in single quotes Syntax: to_char(date,'FORMAT') select to_char(sysdate,'DD/MM/YYYY') from ...