Python - Datetime conversation, matching .7930000Z?

Question

Im trying to convert a date time into a human friendly format but keep getting errors in the conversion, im not what im missing to match the current format.

I think its 7930000Z thats causing the issue, everything else seems straight forward.

Ive tried, %fZ and %SZ, no luck thus far

>>> datetime.strftime(datetime.strptime('2017-09-18T21:20:33.7930000Z', '%Y-%m-%dT%H:%M:%S.%fZ'),'%d/%m/%y %H:%M:%S')
Traceback (most recent call last):
  File "<console>", line 1, in <module>
  File "/usr/local/lib/python3.6/_strptime.py", line 565, in _strptime_datetime
    tt, fraction = _strptime(data_string, format)
  File "/usr/local/lib/python3.6/_strptime.py", line 362, in _strptime
    (data_string, format))
ValueError: time data '2017-09-18T21:20:33.7930000Z' does not match format '%Y-%m-%dT%H:%M:%S.%fZ'

`'%Y-%m-%dT%H:%M:%S.%f0Z'` – Stop harming Monica Oct 13 '17 at 08:27 — Stop harming Monica, Oct 13 '17 at 08:27
Will fail if the last digit is not a 0 :-/ – Benjamin Oct 13 '17 at 08:28 — Benjamin, Oct 13 '17 at 08:28

score 1 · Accepted Answer · answered Oct 13 '17 at 08:21

1

Maybe %f is for microseconds and they are "Between 0 and 999999 inclusive"(https://docs.python.org/3/library/datetime.html)

And a post about nanoseconds parsing: Format Nanoseconds in Python

answered Oct 13 '17 at 08:21

Benjamin

3,350
4
24
49

Yes and you have 7 digits, not 6 – Benjamin Oct 13 '17 at 08:24
ah I see, maybe the last end is timezone? should I just strip it? – AlexW Oct 13 '17 at 08:29
either you strip last digit or if you are sure it is always a 0 you can use @Goyo format – Benjamin Oct 13 '17 at 08:30
ive just got rid of it all with re.sub(r'.\d*Z', '', '2017-09-18T21:20:33.7930000Z'), then converted after – AlexW Oct 13 '17 at 08:54

Python - Datetime conversation, matching .7930000Z?

1 Answers1