How to insert a date into MySQL using Python?

0 votes

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?

Jul 15 in Python by akhtar
• 17,690 points
29 views

1 answer to this question.

0 votes

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'),))
    answered Jul 15 by MD
    • 40,740 points

    Related Questions In Python

    0 votes
    1 answer
    +2 votes
    2 answers

    How to make a laplacian pyramid using OpenCV python?

    down voteacceptTheeThe problem is that you're iterating ...READ MORE

    answered Apr 3, 2018 in Python by charlie_brown
    • 7,780 points
    2,503 views
    0 votes
    2 answers

    How do I connect to a MySQL Database in Python?

    connect mysql database with python import MySQLdb db = ...READ MORE

    answered Mar 28, 2019 in Python by rajesh
    • 1,230 points
    470 views
    0 votes
    1 answer

    I'm using Python 2.7 to convert an XML response (from a REST call to Atlassian Fisheye) into an HTML table.

    You don't have a template matching tabularQueryResult in your ...READ MORE

    answered Oct 4, 2018 in Python by Priyaj
    • 57,550 points
    143 views
    0 votes
    1 answer
    0 votes
    1 answer

    How to create MySql database using Python?

    Hi@akhtar, You need to use MySQL connector in ...READ MORE

    answered Jul 15 in Python by MD
    • 40,740 points
    19 views
    0 votes
    1 answer

    mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

    Hi@akhtar, According to SQL documentation for python library. you ...READ MORE

    answered Jul 15 in Python by MD
    • 40,740 points
    113 views
    0 votes
    1 answer

    ProgrammingError: not all arguments converted during string formatting

    Sorted!!!! just found the solution, 1 - apparently ...READ MORE

    answered Sep 10, 2018 in Python by Priyaj
    • 57,550 points
    8,594 views
    0 votes
    1 answer

    How to transfer multiple lines in a file using python?

    Hi@akhtar, I don't know it will help you ...READ MORE

    answered Mar 31 in Python by MD
    • 40,740 points
    86 views
    0 votes
    1 answer

    How to crop face from a photo using cv2 in python?

    Hi@akhtar, You can do this task using cv2 ...READ MORE

    answered Apr 9 in Python by MD
    • 40,740 points
    65 views