Convert timestamps with offset to datetime obj using strptime

by

The Python 2 strptime() function indeed does not support the %z format for timezones (because the underlying time.strptime() function doesn’t support it). You have two options:

  • Ignore the timezone when parsing with strptime:

    time_obj = datetime.datetime.strptime(time_str[:19], '%Y-%m-%dT%H:%M:%S')

  • use the dateutil module, it’s parse function does deal with timezones:

    from dateutil.parser import parse
time_obj = parse(time_str)

Quick demo on the command prompt:

>>> from dateutil.parser import parse
>>> parse("2012-07-24T23:14:29-07:00")
datetime.datetime(2012, 7, 24, 23, 14, 29, tzinfo=tzoffset(None, -25200))

You could also upgrade to Python 3.2 or newer, where timezone support has been improved to the point that %z would work, provided you remove the last : from the input, and the - from before the %z:

>>> import datetime
>>> time_str = "2012-07-24T23:14:29-07:00"
>>> datetime.datetime.strptime(time_str, '%Y-%m-%dT%H:%M:%S%z')
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/Users/mj/Development/Library/buildout.python/parts/opt/lib/python3.4/_strptime.py", line 500, in _strptime_datetime
    tt, fraction = _strptime(data_string, format)
  File "/Users/mj/Development/Library/buildout.python/parts/opt/lib/python3.4/_strptime.py", line 337, in _strptime
    (data_string, format))
ValueError: time data '2012-07-24T23:14:29-07:00' does not match format '%Y-%m-%dT%H:%M:%S%z'
>>> ''.join(time_str.rsplit(':', 1))
'2012-07-24T23:14:29-0700'
>>> datetime.datetime.strptime(''.join(time_str.rsplit(':', 1)), '%Y-%m-%dT%H:%M:%S%z')
datetime.datetime(2012, 7, 24, 23, 14, 29, tzinfo=datetime.timezone(datetime.timedelta(-1, 61200)))

More Related Contents:

  1. What exactly does the T and Z mean in timestamp?
  2. How do I parse an ISO 8601-formatted date?
  3. How to convert integer timestamp to Python datetime
  4. How to convert integer timestamp into a datetime
  5. How to convert a timezone aware string to datetime in Python without dateutil?
  6. Convert datetime to Unix timestamp and convert it back in python
  7. ISO to datetime object: ‘z’ is a bad directive [duplicate]
  8. Python UTC datetime object’s ISO format doesn’t include Z (Zulu or Zero offset)
  9. Generate RFC 3339 timestamp in Python [duplicate]
  10. Python pandas convert datetime to timestamp effectively through dt accessor
  11. Convert an RFC 3339 time to a standard Python timestamp
  12. How to convert Python’s .isoformat() string back into datetime object [duplicate]
  13. How to combine year, month, and day columns to single datetime column?
  14. How to print a date in a regular format?
  15. subtract two times in python
  16. Parsing datetime strings containing nanoseconds
  17. Get current time in milliseconds in Python?
  18. Generating random dates within a given range in pandas
  19. Inserting a Python datetime.datetime object into MySQL
  20. datetime from string in Python, best-guessing string format
  21. Spark DataFrame TimestampType – how to get Year, Month, Day values from field?
  22. Python/Pandas convert string to time only
  23. Convert dataframe index to datetime
  24. How to convert a Date string to a DateTime object?
  25. Seaborn tsplot does not show datetimes on x axis well
  26. Group DataFrame in 5-minute intervals
  27. Python summing up time
  28. Ceil a datetime to next quarter of an hour
  29. Python: Matplotlib avoid plotting gaps
  30. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13

Leave a Comment