title: ORA-01843: not a valid month
body: <p>I am having an issue with my sql query.</p>
  
  <pre><code>  create table rental
    (     
    rental_id NUMBER(5) NOT NULL,
    rental_date timestamp NOT NULL, 
    inventory_id NUMBER(5) NOT NULL,
    customer_id NUMBER(5) NOT NULL,
    return_date timestamp NOT NULL,
    staff_id NUMBER(5) NOT NULL,
    constraint rental_primary PRIMARY KEY (rental_id),
    constraint rental_foreign FOREIGN KEY (inventory_id) REFERENCES 
  
    inventory(inventory_id),
    constraint rental_foreign2 FOREIGN KEY (customer_id) REFERENCES
    customer(customer_id),
    constraint rental_foreign3 FOREIGN KEY (staff_id) REFERENCES staff(staff_id),
    constraint rental_unique_rental_date unique (rental_date),
    constraint rental_unique_inventory_id unique (inventory_id),
    constraint rental_unique_customer_id unique (customer_id),
    constraint rental_rental_date check(to_char(rental_date,'YYYY/MM/DD HH:MI:SS AM') 
    between '2005/01/01 00:00:01 AM' AND '12/31/2015 11:59:59 PM'),
    constraint rental_return_date check(to_char(return_date,'YYYY/MM/DD HH:MI:SS AM') 
    between '2005/01/01 00:00:01 AM' AND '12/31/2015 11:59:59 PM')
    );
  </code></pre>
  
  <p>when I am trying to insert data,
  It is throwing this error "ORA-01843: not a valid month".
  Can anyone please suggest me what type of datatype can I use for rental_date and return date to get through this situation?
  Here is my sample data which I am trying to upload</p>
  
  <pre><code>    rental_date                   return_date
     5/24/2011  10:53:30 PM        5/26/2011  10:04:30 PM
  </code></pre>
  
  <p>Note : I can see this type of format in my excel sheet where I have my data but when I get error </p>
  
  <pre><code>       "ORA-01843: not a valid month    
       Row 145: 144,  2011-05-25 23:49:56  ,1689,357,  2011-06-01 21:41:56  ,2"
  </code></pre>
  
  <p>I am observing different format of time here.</p>
  
  <p>Can anyone suggest me a solution?</p>
  
  <p>Thanks in advance.</p>