How to insert a date into MySQL using Python

Question

Hi Guys,

I have installed MySql connector so that I can connect MySql server from my Python code. Can anyone tell me how do I insert a date into MySQL using Python?

Answer 1

Hi@akhtar,
You can use the DateTime module to insert a date into MySql. Use the below-given code in your program.

import datetime 
a = datetime.datetime.strptime('my date', "%b %d %Y %H:%M") 
cursor.execute('INSERT INTO myTable (Date) VALUES(%s)', (a.strftime('%Y-%m-%d %H:%M:%S'),))