I have a string that says "Oct. 2, 2017, midnight" and want to convert it to a UTC timestamp.
Is there any good way to do this?
6
-
are all the hours midnight?usernamenotfound– usernamenotfound2018-01-23 19:37:38 +00:00Commented Jan 23, 2018 at 19:37
-
Yeah all the hours are midnight. I actually did a little searching and found it seems to just be a normal date object with the format: 2017-10-02 00:00:00+00:00demluckycharms– demluckycharms2018-01-23 19:39:34 +00:00Commented Jan 23, 2018 at 19:39
-
Did you copy/paste your post title into Google and go through all the solutions?dfundako– dfundako2018-01-23 19:40:26 +00:00Commented Jan 23, 2018 at 19:40
-
1Possible duplicate of Convert string date to timestamp in PythonScott Mermelstein– Scott Mermelstein2018-01-23 19:43:42 +00:00Commented Jan 23, 2018 at 19:43
-
1@ScottMermelstein I thought the same but the "midnight" string is kind of an interesting variant on the common problem.r.ook– r.ook2018-01-23 19:44:25 +00:00Commented Jan 23, 2018 at 19:44
|
Show 1 more comment
1 Answer
Considering all your data is at midnight, the easiest way is to remove the , midnight string and convert it.
import datetime
import pytz
s = "Oct. 2, 2017, midnight"
dt = datetime.datetime.strptime(s.split(', midnight')[0], '%b. %d, %Y')
dt_utc = dt.astimezone(pytz.utc)
If there are other time indicated, you'll want to interpret the literals of the time and pass it onto strptime() accordingly.
