Building correct MySQL datetime formatted string for yesterday in Python

Question

I have tried something like this:

datetime.strftime('%Y-%m-%d %H:%M:%S',(datetime.now() - timedelta(hours=24))

I just want to get a MySQL formatted string for yesterday. The above is not working as strftime expects a datetime.date and I gave a string.

`(dt.datetime.now() - dt.timedelta(hours=24)).strftime('%Y-%m-%d %H:%M:%S')` — mechanical_meat, Jul 09 '15 at 21:04
@bernie surprised that works! I considered that but didn't think that would actually work. Thanks! — ComputerLocus, Jul 09 '15 at 21:15
@bernie feel free to submit an answer, this did solve it. However, I removed the `dt.` parts. — ComputerLocus, Jul 09 '15 at 21:24
Beware timezone issues: [How can I subtract a day from a python date?](http://stackoverflow.com/q/441147/4279) — jfs, Jul 10 '15 at 10:04

score 1 · Accepted Answer · answered Jul 09 '15 at 21:27

1

You want instead:

(datetime.now() - timedelta(hours=24)).strftime('%Y-%m-%d %H:%M:%S')

answered Jul 09 '15 at 21:27

mechanical_meat

1 Answers1