How can I extract the day of the week and the hour of the day from a timestamp in this format?
2020-08-17T01:54:38.000Z
So for the example above I would get Monday and 01 in return.
Asked
Active
Viewed 514 times
1 Answers
1
You could parse the string into a datetime object using strptime with a custom format, and then extract the info you need from it:
from datetime import datetime
dateStr = '2020-08-17T01:54:38.000Z'
dt = datetime.strptime(dateStr,'%Y-%m-%dT%H:%M:%S.%fZ')
hour = dt.strftime('%H')
dayOfWeek = dt.strftime('%A')
Mureinik
- 297,002
- 52
- 306
- 350
-
I got this error: ValueError: time data '2020-08-17T01:54:48.504Z' does not match format '%Y-%m-%dT%H:%M:%S.000Z' – hokoio Dec 18 '20 at 19:15
-
@hokoio sorry, I missed the millisecond part. Edited and fixed. – Mureinik Dec 18 '20 at 19:16
-
1sorry i didn't mention in my question. Is there anyway that the hour can return 01, 02, 03 instead of just 1, 2 or 3? – hokoio Dec 18 '20 at 19:20
-
@hokoio sure - you can format it with `strftime` - see my edited answer – Mureinik Dec 18 '20 at 19:22