title: Inserting TimeStamp Column from List to MYSQL using Python
body: <p>I have a List like shown below (The list has been obtained by converting a pandas dataframe to a list. The pandas dataframe is obtained from an excel):</p>
  
  <ul>
  <li><strong>L = [[3982, 36308220021, Timestamp('2017-07-01 14:10:37'), '', Timestamp('2017-07-01 14:20:48'), '', 0, 0]]</strong></li>
  </ul>
  
  <p>Note: L is actually a nested list with more than 5000 entries.</p>
  
  <p>I am inserting the values in MySQL using python . There I have defined the column as "<strong>dateACW DATETIME</strong>" during <strong>CREATE TABLE</strong> operations. Similar column names have been defined for other Timestamp values from the list. During insertion in MySQL, it gives following error: <strong><em>"AttributeError: 'Timestamp' object has no attribute 'translate'"</em></strong>. I tried using TIMESTAMP datatype instead of DATETIME. That did not help. Please help me out with explanation on whats the problem.</p>