format to take month in oct format in oracle code example Example: date format in oracle e.g., 01-JAN-17