I need to convert datetime to date without seconds in python

Question

I need to convert datetime to date without seconds in python, how to execute this:

from datetime import datetime
dt = datetime.strptime('2016-06-01 16:05:20', '%Y-%m-%d').date()
print dt

Result:

Traceback (most recent call last):
  File "teste.py", line 5, in <module>
    dt = datetime.strptime('2016-06-01 16:05:20', '%Y-%m-%d').date()
  File "/usr/lib/python2.7/_strptime.py", line 328, in _strptime
    data_string[found.end():])
ValueError: unconverted data remains:  16:05:20

I've tried everything
Can help?

Possible duplicate of [How do I convert datetime to date (in Python)?](http://stackoverflow.com/questions/3743222/how-do-i-convert-datetime-to-date-in-python) — Bakri Bitar, Jun 01 '16 at 22:30
*"I've tried everything"* - where *is* what you've tried, then? Broadly, either: 1. extract just the date part then parse it; or 2. parse the whole thing then call `.date()` to discard the time. — jonrsharpe, Jun 01 '16 at 22:30
@BakriBitar The answers there just say to use `.date()`, which he's already doing. His problem is with the parsing. — Barmar, Jun 01 '16 at 22:58

score 2 · Accepted Answer · answered Jun 01 '16 at 23:00

2

Even though you're going to discard the time, you still need to include it in your format string, since it exists in the string you're parsing. strptime() doesn't know that you don't care about the time, it just needs to match the input against the format string.

dt = datetime.strptime('2016-06-01 16:05:20', '%Y-%m-%d %H:%M:%S').date()

answered Jun 01 '16 at 23:00

Barmar

741,623
53
500
612

`pedido_data = datetime.datetime.strptime(pedido_data, '%Y-%m-%d %H:%M:%S').date() TypeError: must be string, not datetime.datetime` – rodrigosillos Jun 01 '16 at 23:41
What is the value of `pedido_data`? – Barmar Jun 01 '16 at 23:45
It should be a string like `'2016-06-01 16:05:20'`, but that error indicates that it's already a `datetime`. – Barmar Jun 01 '16 at 23:45
It is already a date time stored in mysql, but I need to remove the second – rodrigosillos Jun 01 '16 at 23:50
You want to remove the second, but leave the hours and minutes? – Barmar Jun 01 '16 at 23:51
The error message indicates that you already parsed it. If so, you should just use `pedido_data.date()`. – Barmar Jun 01 '16 at 23:52
`AttributeError: 'NoneType' object has no attribute 'date'` – rodrigosillos Jun 02 '16 at 00:05
That means `pedido_data` contains `None`, not a datetime. – Barmar Jun 02 '16 at 00:06
`pedidos = con.cursor.fetchall() for pedido in pedidos: pedido_data = pedido[4]` – rodrigosillos Jun 02 '16 at 00:07
I guess that row of the database table contains `NULL` in this column. – Barmar Jun 02 '16 at 00:07
`print pedido_data` response `2016-06-01 16:05:20` – rodrigosillos Jun 02 '16 at 00:08
Either edit your question or post a new question. I can't answer you like this. – Barmar Jun 02 '16 at 00:09

I need to convert datetime to date without seconds in python

1 Answers1