title: How to add oracle TRUNC(SYSDATE-100,'Q') to MySQL
body: <p>I have MySQL installed and I have an oracle script with me and I create schemas and tables and stuck with trunc and quarter in oracle and want them to insert in MySQL.</p>
  
  <p>how to use trunc and q while inserting into mysql? </p>
  
  <pre><code>INSERT INTO ASSIGNMENT (ASSIGNMENT_ID, CONSULTANT_ID,CLIENT_ID,START_DATE,END_DATE,PAY,COMMENTS) 
    VALUES (1, 2, 1, date_format(quarter(SYSDATE()-100),'%d-%b-%Y'),date_format(quarter(SYSDATE()-100),'%d-%b-%Y')+31,500, null);
  
  date_format(quarter(SYSDATE()-100),'%d-%b-%Y'),date_format(quarter(SYSDATE()-100),'%d-%b-%Y')+31,500
  </code></pre>
  
  <blockquote>
    <p>Error Code: 1292. Incorrect datetime value: '4' Error Code: 1292.
    Incorrect date value: 'Q' for column 'start_date' at row 1 Error Code:
    1292. Incorrect date value: 'Q' for column 'start_date' at row 1</p>
  </blockquote>