+

How do I store and retrieve a date in a MySQL database using Python?

To insert a date into a MySQL database, you must have a column of type date or datetime in your table. Once you have done that, you will need to convert the date to string format before inserting it into the database.

You can use the strftime formatting function of the datetime module to do this. 

Example

 from datetime import datetime now = datetime.now () id = 1 formatted_date = now.strftime (`% Y- % m-% d% H:% M:% S`) # Assuming you have a cursor named cursor you want to execute this query on: cursor.execute (`insert into table (id, date_created) values ​​(% s,% s) `, (id, formatted_date)) 

Doing this will try to insert the (id, date) tuple into your table.





When you select a date from the database using a select query, you will need to parse it back into a datetime object using functions such as strptime.

 from datetime import datetime # Assuming you have a cursor named cursor you want to execute this query on: cursor.execute (`select id, date_created from table where id = 1`) # if you inserted the row above, you can get it back like this id, date_str = cursor.fetchone () # date is returned as a string in format we sent it as. So parse it using strptime created_date = datetime.strptime (date_created, `% Y-% m-% d% H:% M:% S`) 

This will get the created date and parse it for a datetime object .



Get Solution for free from DataCamp guru