python date format change

Question

How can I change the format of a date

var_time="2021-05-17T00:00:00Z"

to 2021-05-17 00:00:00?

You're asking how to replace the capital `T` and drop the `Z`? This is covered in any tutorial on string processing. If this is a `datetime` object -- as it should be, if you need to do this more than once -- then the formatting info is in the package documentation. — Prune, Jun 07 '21 at 14:55
Why do you need to "convert" anything? `string.split('T')` would get you half way to what you want — OneCricketeer, Jun 07 '21 at 14:58
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, Jun 07 '21 at 15:16

score 2 · Answer 1 · answered Jun 07 '21 at 15:11

The Data format you have is ISO8601 so you need to convert this to the desired format. Here is what I did:

from datetime import datetime

s= "2021-05-17T00:00:00Z"

yourdate = datetime.fromisoformat(s.replace('Z','+00:00'))
yourdate.strftime('%Y-%m-%d %H:%M:%S')

The Output will be this:

'2021-05-17 00:00:00'

I don't know if this is the best way but I hope I could help.

Source:

score 0 · Accepted Answer · answered Jun 07 '21 at 14:59

0

The below should work after taking off the trailing "Z" :

from datetime import datetime
new_var_time = datetime.fromisoformat(var_time[:-1]).strftime("%Y-%m-%d %H:%M:%S")

answered Jun 07 '21 at 14:59

AmineBTG

597
3
13

thanks Amin, it is working – bbb Jun 07 '21 at 15:02
@George Welcome ! Consider validating / accepting the answer plz - thanks – AmineBTG Jun 07 '21 at 15:03
sure, how can we convert this new_var_time into unixepoch time? – bbb Jun 07 '21 at 15:04
@George `posix_var_time = datetime.fromisoformat(var_time[:-1]).timestamp()` – AmineBTG Jun 07 '21 at 15:07
could you correct, posix_var_time = datetime.fromisoformat(var_time[:-1]).timestamp() – – bbb Jun 07 '21 at 15:08
@George I don't understand. Correct what ? – AmineBTG Jun 07 '21 at 15:15
do not strip the `Z` - it denotes UTC; if you just ignore it, you'll get naive datetime which Python treats as local time, not UTC. – FObersteiner Jun 07 '21 at 15:17

score 0 · Answer 3 · answered Jun 07 '21 at 15:01

0

I am not sure whether your var_time is a string or a time/datetime obeject? If this variable is a string, you can use the following:

import datetime

string = '2021-05-17T00:00:00Z'
date_dt1 = datetime.datetime.strptime(string, '%Y-%m-%dT%H:%M:%SZ')
print(date_dt1)

print:

2021-05-17 00:00:00

answered Jun 07 '21 at 15:01

wing

39
1

1

do not use a literal `Z` in the parsing directive (use `%z` instead) - the Z denotes UTC; if you just ignore it, you'll get naive datetime which Python treats as local time, not UTC. – FObersteiner Jun 07 '21 at 15:18
@MrFuppes, you are right. Thank you for the note. – wing Jun 07 '21 at 17:10

python date format change

3 Answers3