check which datetime format is supported in oracle code example Example: date format in oracle e.g., 01-JAN-17