I try to parse string to time-stamp with timezone format.
here is an example
"2016-02-18 16:13:07+09"
i want to know parsing this string format to time-stamp format in python.
how can i do that?
-
yes, but i dont know how can i try this T.TKyehee Kim– Kyehee Kim2016-02-23 08:32:43 +00:00Commented Feb 23, 2016 at 8:32
-
Try writing a simple script that parses something much simpler than what you want to parse, using time.strptime, something like "2016-02-18"GLaDOS– GLaDOS2016-02-23 08:35:35 +00:00Commented Feb 23, 2016 at 8:35
-
hmm... just that's all? i need more efficient methodKyehee Kim– Kyehee Kim2016-02-23 08:46:55 +00:00Commented Feb 23, 2016 at 8:46
-
Please include a code example of your trial and error in your question.GLaDOS– GLaDOS2016-02-23 08:49:21 +00:00Commented Feb 23, 2016 at 8:49
-
Just that's all. what is this situation, i have to get the timestamp with timezone data from database, then i need insert another database. but when i bring that timestamp from first database, timestamp format is transformed to string format. So i need parse this string type to timestamp with timezone formatKyehee Kim– Kyehee Kim2016-02-23 08:53:26 +00:00Commented Feb 23, 2016 at 8:53
|
Show 3 more comments
3 Answers
Is the UTC offset format in your string +09 or +0900 ?
If the offset in your string is 0900 you can use the below .If your UTC offset is only +09 as you mentioned in your question , you can pad the string with 00 and get the below code to work .
Code:
import datetime
time="2016-02-18 16:13:07+0900"
new_time=datetime.datetime.strptime(time,"%Y-%m-%d %H:%M:%S%z")
print(new_time)
new_time_python=datetime.datetime.strftime(new_time,"%m-%d-%y")
print(new_time_python)
Output
2016-02-18 16:13:07+09:00
02-18-16
Comments
dateutil might be a suitable library for your purposes:
from dateutil.parser import parser
p = parser()
d = p.parse('2016-02-18 16:13:07+09'.decode('utf-8')) # must be unicode string
d
>>> datetime.datetime(2016, 2, 18, 16, 13, 7, tzinfo=tzoffset(None, 32400))
Comments
If the UTC offset may be specified both as +HH and +HHMM format then you could use str.ljust() method to normalize the input time string. Then you could use .strptime() to parse it:
#!/usr/bin/env python3
from datetime import datetime
time_string = "2016-02-18 16:13:07+09"
dt = datetime.strptime(time_string.ljust(24, "0"), "%Y-%m-%d %H:%M:%S%z")
# -> datetime.datetime(2016, 2, 18, 16, 13, 7,
# tzinfo=datetime.timezone(datetime.timedelta(0, 32400)))
If your Python version doesn't support %z, see How to parse dates with -0400 timezone string in python?
2 Comments
marcosbdm
working on python 3.8 but you have to use a 4 digit offset: (+0900 instead of +09)
jfs
@marcosbdm: the code works as is ideone.com/1gHBBd