title: Oracle insert timestamp - AM/A.M. or PM/P.M. required
body: <p>In SQL Developer I have created an export, .sql file, (a really big one). It contains hundreds of inserts like :</p>
  
  <pre><code>"Insert into SCHEMA.TABLE (
   ... ,
   CREATEDATE,
   MODIFIEDDATE,
   ....
  ) 
  values (
   ... , 
   to_timestamp('20-AUG-12 01.09.53.271000000 AM','DD-MON-RR HH.MI.SS.FF AM'),
   to_timestamp('20-AUG-12 01.09.53.271000000 PM','DD-MON-RR HH.MI.SS.FF PM'),
   ...
  );"
  </code></pre>
  
  <p>When I run it in SQL Developer, it works fine. But I can't import a bit .sql file with SQL Developer (or I don't know how to do it).</p>
  
  <p>When I run it with SQL*Plus I get following error:</p>
  
  <blockquote>
    <p>ORA-01855: AM/A.M. or PM/P.M. required</p>
  </blockquote>
  
  <p>When I remove the AM/PM keywords from the insert, SQL*Plus can insert row, with them, no luck. What is the problem with AM / PM?</p>
  
  <p>Here is the exact insert command:</p>
  
  <pre><code>Insert into SCHEMA.TABLE(
  
  ENTRYID,GROUPID,COMPANYID,USERID,USERNAME,CREATEDATE,MODIFIEDDATE,
  CLASSNAMEID,CLASSPK,CLASSUUID,VISIBLE,STARTDATE,ENDDATE,PUBLISHDATE,
  EXPIRATIONDATE,MIMETYPE,TITLE,DESCRIPTION,SUMMARY,URL,HEIGHT,WIDTH,
  PRIORITY,VIEWCOUNT
  
  ) values (
  
  11902,11005,10136,10178,'Test Test',
  to_timestamp('20-AUG-12 01.09.53.271000000 AM','DD-MON-RR HH.MI.SS.FF AM'),
  to_timestamp('20-AUG-12 01.09.53.271000000 PM','DD-MON-RR HH.MI.SS.FF PM'),
  10076,11900,'AAA',1,null,null,null,null,null,
  'ABC','XyZ',null,null,0,0,0,2563
  
  );
  </code></pre>