title: Inserting date with month name in datetime field column
body: <p>I am trying to insert  a date &amp; time value into table</p>
  
  <p>Here is my query</p>
  
  <pre><code>Insert INTO tableName(attDate) VALUES ("22-Sep-2019 19:28:10") 
  </code></pre>
  
  <p>Here attDate column is having type datetime,  i have tried above query using DATE_FORMAT function but no luck. And also i am not suppose to use the date value in a variable. Will anybody guide me to proper way.</p>