title: Convert column of Timestamps to datetime.datetime. Works on 1 row, not on column
body: <p>I've looked at every answer on this site, including this one: <a href="https://stackoverflow.com/questions/22554339/convert-timestamp-to-datetime-datetime-in-pandas-series">convert timestamp to datetime.datetime in pandas.Series</a> and nothing is working. It always returns a Timestamp.</p>
  <p>I have a dataframe with a <code>time</code> column which contains <code>class 'pandas._libs.tslibs.timestamps.Timestamp'&gt;</code> values of the format <code>2022-06-24 15:07:52</code>.</p>
  <p>I'm trying to use pandas' <code>pd.df.to_sql</code> function to write my entire dataframe to a MySQL database. I'm running into an error however because the type of the <code>time</code> column in the database is <code>Datetime</code>, so I need to convert the Timestamps to Datetime format in the dataframe.</p>
  <p>I've tried <code>df['time'] = pd.to_datetime(df['time'])</code>, which returns Timestamps.</p>
  <p>The only thing that worked is <code>df['time'][0].to_pydatetime()</code> when applied to a single row.
  However when I try <code>df['time'] = df['time'].apply(lambda x: x.to_pydatetime())</code>, it doesn't work. The elements are still Timestamps.</p>
  <p>I read in another answer somewhere that <code>to_pydatetime</code> won't work on a Series or column, so I also tried to extract the column as a list, then apply <code>to_pydatetime()</code> to its elements (which works, each element is converted to <code>datetime.datetime</code>) and then put that list back into the dataframe. However when I do that, each element is converted again to a Timestamp...</p>