comparing python datetime to mysql datetime

Question

I'm a complete beginner, I have a test mysql db set up. I am currently trying to check if the backup start time listed in the database is before 12pm on the current day. The time was entered into the table using the following:

UPDATE Clients SET backup_started=NOW() WHERE id=1;

What I am currently trying is:

now = datetime.datetime.now()
today12am = now.replace(hour=0, minute=0, second =0,)
dbu.cursor.execute('SELECT id, company_name, backup_started,\
backup_finished FROM Clients WHERE backup_started>' + today12am)
data = dbu.cursor.fetchone()
print (data)

I understand that it is trying to compare a datetime.datetime to a string and this is where it is having problems. My question is what is the best way to accomplish this?

error:

TypeError: cannot concatenate 'str' and 'datetime.datetime' objects

alecxe · Accepted Answer · 2015-04-01 15:58:45Z

2

Make your query parameterized:

dbu.cursor.execute("""
    SELECT 
        id, company_name, backup_started, backup_finished 
    FROM 
        Clients 
    WHERE 
        backup_started > %s""", (today12pm, ))

answered Apr 1, 2015 at 15:58

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

lafferc · Accepted Answer · 2015-04-01 16:05:28Z

1

use strftime

dbu.cursor.execute('SELECT id, company_name, backup_started,\
backup_finished FROM Clients WHERE backup_started> %s' %today12pm.strftime('%Y-%m-%d %H:%M:%S'))

check that the format is correct

answered Apr 1, 2015 at 16:05

lafferc

2,7793 gold badges26 silver badges37 bronze badges

Collectives™ on Stack Overflow

comparing python datetime to mysql datetime

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related