Convert 2020-09-01T00:00:00-05:00 timestamp to dd-mm-yyyy

Question

Hi I am trying to convert the following time format

2020-08-28T13:42:00.298363-05:00

to

28-Sept-2020

I am using the following code but it does not work.

from datetime import datetime
 
start_time = "2020-08-28T13:42:00.298363-05:00"
start_period_obj = datetime.strptime(start_time, "%Y-%m-%dT%H:%M:%f.%-s-%z)
    print(start_period_obj)

and the output is

File "time conveter.py", line 19
    start_period_obj = datetime.strptime(start_time, "%Y-%m-%dT%H:%M:%f.%-s-%z)
                                                                              ^
SyntaxError: EOL while scanning string literal

I have added an answer if it works please check mark and upvote the answer. — Grayrigel, Sep 28 '20 at 22:23
@ChrisCharley Please explain the negative vote to me? did anyone even try running the code? — Grayrigel, Sep 28 '20 at 22:30
@Grayrigel I upvoted you, though I didn't see it changed. I don't know why it didn't change — Vince V Vanhoyte, Sep 28 '20 at 23:23
Does this answer your question? [How do I parse an ISO 8601-formatted date?](https://stackoverflow.com/questions/127803/how-do-i-parse-an-iso-8601-formatted-date) — FObersteiner, Sep 29 '20 at 06:46

Query Stash · Answer 1 · 2020-09-29T12:02:04.850

0

Your code is missing the closing quote at the end of the datetime format string, which is causing the error message you see. You also have an issue with the actual format string as well, as pointed out by @ChrisCharley

This start_period_obj = datetime.strptime(start_time, "%Y-%m-%dT%H:%M:%f.%-s-%z)

Should be start_period_obj = datetime.strptime(start_time, "%Y-%m-%dT%H:%M:%S.%f%z")

To then generate your desired format you can use:

start_period_obj.strftime("%d-%b-%Y")

See here for full details https://docs.python.org/2/library/datetime.html#strftime-and-strptime-behavior

edited Sep 29 '20 at 12:02

answered Sep 28 '20 at 22:12

Query Stash

149
5

The parsing string should read `"%Y-%m-%dT%H:%M:%S.%f%z"` – Chris Charley Sep 28 '20 at 22:36
1

Thank you for the correction on the original parsing string, I had missed that part being incorrect in the OP. – Query Stash Sep 28 '20 at 22:38

Grayrigel · Accepted Answer · 2020-09-29T07:49:55.380

0

Try this:

from datetime import datetime
 
start_time = "2020-08-28T13:42:00.298363-05:00"

#removing the time information since, you don't want in the final output anyway
start_time  = start_time.split('T')[0]
start_period_obj = datetime.strptime(start_time, "%Y-%m-%d")
start_period_obj = start_period_obj.strftime("%d-%b-%Y")
print(start_period_obj)

Or this one liner:

start_period_obj = datetime.strptime(start_time.split('T')[0], "%Y-%m-%d").strftime("%d-%b-%Y")
print(start_period_obj)

Output:

'28-Aug-2020'

edited Sep 29 '20 at 07:49

answered Sep 28 '20 at 22:20

Grayrigel

3,474
5
14
32

1

this is a one-liner (Python 3.7)... `datetime.fromisoformat("2020-08-28T13:42:00.298363-05:00").strftime("%d-%b-%Y")` – FObersteiner Sep 29 '20 at 06:44
Thanks. well, I didn't know about it. Added one line solution using `strptime` and `strftime` probably slower but works. – Grayrigel Sep 29 '20 at 07:56
1

ok my comment might have been misleading, I didn't mean to propose a one-liner for it being a one-liner ;-) `fromisoformat` is more readable in my opinion and [very efficient](https://stackoverflow.com/questions/13468126/a-faster-strptime). – FObersteiner Sep 29 '20 at 07:58
1

I understand you didn't mean to propose one line solution. It is just that I got random dislikes for posting this solution and I can't figure out why. So, I figured it could one line people. I agree `fromisoformat` clearly is much more readable is a much better option. Thanks. – Grayrigel Sep 29 '20 at 08:08
well, better not to think too much about getting downvotes. The other way around, I don't allow myself to downvote without leaving a comment. In this case, I just left the comment ^^ – FObersteiner Sep 29 '20 at 08:21

Convert 2020-09-01T00:00:00-05:00 timestamp to dd-mm-yyyy

2 Answers2