TIME FORMAT WHILE CREATING TABLE IN ORACLE code example Example: date format in oracle e.g., 01-JAN-17