Python MySQL date time format

Question

I have a model:

class errors(models.Model):
    date           = models.DateTimeField()
    msg            = models.CharField(max_length=500)

I simply cannot get the date format right when inserting. I do

msg = "error" 
date = datetime.datetime.now()

cursor = connection.cursor()
cursor.execute("INSERT INTO cmt_errors('date', 'msg') VALUES (%s, %s)", (date, msg))

How should I format date so I don't get a syntax error? I am, btw, able to do a select so I've got the tables imported, etc.

unutbu · Accepted Answer · 2012-01-07 10:26:14Z

1

Do not put single-quotes around the column names:

"INSERT INTO cmt_errors(date, msg) VALUES (%s, %s)"

answered Jan 7, 2012 at 10:26

unutbu

886k197 gold badges1.9k silver badges1.7k bronze badges

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

1 Comment

user984003 Over a year ago

DOH! Thank-you! Solves my problem. I had been staring myself blind.

Collectives™ on Stack Overflow

Python MySQL date time format

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related