HOW TO SELECT DATE WITH TIME FORMATE IN ORACLE SQL code example Example: specific date format oracle TO_CHAR (TO_DATE('0297','MM/YY'), 'MM/YY')