How to convert String Datetime to timestamp in Python?

Question

I want to convert this string datetimestring = 'Fri, 08 Jun 2012 22:40:26 GMT' to timestamp using python.

I tried

 timestamp = time.mktime(time.strptime(datetimestring, '%a, %d %B %Y %H:%M:%S GMT'))

but reports regex error.

Don't just tell us you got an error, give us the actual error. — Gareth Latty
– Gareth Latty, Commented Jun 9, 2012 at 0:47
Especially because there is no regex in the code you pasted :-) — jedwards
– jedwards, Commented Jun 9, 2012 at 0:54

Xiao · Accepted Answer · 2013-11-28 03:27:05Z

6

You're using %B, which corresponds to the full month name, but you only have the abbreviated name. You should use %b instead:

>>> import time
>>> datetimestring = 'Fri, 08 Jun 2012 22:40:26 GMT' 
>>> timestamp = time.mktime(time.strptime(datetimestring, '%a, %d %B %Y %H:%M:%S GMT'))
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/_strptime.py", line 454, in _strptime_time
    return _strptime(data_string, format)[0]
  File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/_strptime.py", line 325, in _strptime
    (data_string, format))
ValueError: time data 'Fri, 08 Jun 2012 22:40:26 GMT' does not match format '%a, %d %B %Y %H:%M:%S GMT'
>>> timestamp = time.mktime(time.strptime(datetimestring, '%a, %d %b %Y %H:%M:%S GMT'))
>>> timestamp
1339209626.0

edited Nov 28, 2013 at 3:27

Xiao

12.8k2 gold badges31 silver badges38 bronze badges

answered Jun 9, 2012 at 0:52

DSM

355k67 gold badges606 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Plamen Tetevensky · Accepted Answer · 2014-06-18 08:24:25Z

4

import time import dateutil.parser as dateparser

datetimestring = 'Fri, 08 Jun 2012 22:40:26 GMT'
dt = dateparser.parse(datetimestring)
timestamp = int(time.mktime(dt.timetuple()))

answered Jun 18, 2014 at 8:24

Plamen Tetevensky

7027 silver badges9 bronze badges

3 Comments

Plamen Tetevensky Over a year ago

This solution converts different string date formats, so you don't care about the formatting.

Joni Over a year ago

This solution works great! But, i think needed to install this: pypi.python.org/pypi/dateparser

Yuseferi Over a year ago

I think this is better solution because it is not need specified format of date, vote up

user739721 · Accepted Answer · 2016-09-28 18:53:45Z

0

You can use dateparser for this purpose.



import dateparser
>>> dateparser.parse('Fri, 08 Jun 2012 22:40:26 GMT')
datetime.datetime(2012, 6, 8, 22, 40, 26)

answered Sep 28, 2016 at 18:53

user739721

Collectives™ on Stack Overflow

How to convert String Datetime to timestamp in Python?

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related