Change language

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 .



Shop

Learn programming in R: courses

$

Best Python online courses for 2022

$

Best laptop for Fortnite

$

Best laptop for Excel

$

Best laptop for Solidworks

$

Best laptop for Roblox

$

Best computer for crypto mining

$

Best laptop for Sims 4

$

Latest questions

NUMPYNUMPY

psycopg2: insert multiple rows with one query

12 answers

NUMPYNUMPY

How to convert Nonetype to int or string?

12 answers

NUMPYNUMPY

How to specify multiple return types using type-hints

12 answers

NUMPYNUMPY

Javascript Error: IPython is not defined in JupyterLab

12 answers

News


Wiki

Python OpenCV | cv2.putText () method

numpy.arctan2 () in Python

Python | os.path.realpath () method

Python OpenCV | cv2.circle () method

Python OpenCV cv2.cvtColor () method

Python - Move item to the end of the list

time.perf_counter () function in Python

Check if one list is a subset of another in Python

Python os.path.join () method