Parsing datetime in Python..?

by

As @TimPietzcker suggested, the dateutil package is the way to go, it handles the first 3 formats correctly and automatically:

>>> from dateutil.parser import parse
>>> parse("Fri Sep 25 18:09:49 -0500 2009")
datetime.datetime(2009, 9, 25, 18, 9, 49, tzinfo=tzoffset(None, -18000))
>>> parse("2008-06-29T00:42:18.000Z")
datetime.datetime(2008, 6, 29, 0, 42, 18, tzinfo=tzutc())
>>> parse("2011-07-16T21:46:39Z")
datetime.datetime(2011, 7, 16, 21, 46, 39, tzinfo=tzutc())

The unixtime format it seems to hiccough on, but luckily the standard datetime.datetime is up for the task:

>>> from datetime import datetime
>>> datetime.utcfromtimestamp(float("1294989360"))
datetime.datetime(2011, 1, 14, 7, 16)

It is rather easy to make a function out of this that handles all 4 formats:

from dateutil.parser import parse
from datetime import datetime

def parse_time(s):
    try:
        ret = parse(s)
    except ValueError:
        ret = datetime.utcfromtimestamp(s)
    return ret

More Related Contents:

  1. Format timedelta to string
  2. Parsing date with timezone from an email?
  3. How to format date string via multiple formats in python
  4. Converting datetime.date to UTC timestamp in Python
  5. Filtering Pandas DataFrames on dates
  6. Converting string with UTC offset to a datetime object [duplicate]
  7. Trying to mock datetime.date.today(), but not working
  8. Most recent previous business day in Python
  9. type object ‘datetime.datetime’ has no attribute ‘datetime’
  10. How to change the datetime tick label frequency for matplotlib plots
  11. Splitting timestamp column into separate date and time columns
  12. Python Create unix timestamp five minutes in the future
  13. Extract day of year and Julian day from a string date
  14. How to check if the current time is in range in python?
  15. Comparing two date strings in Python
  16. Difference between Python datetime vs time modules
  17. Natural/Relative days in Python
  18. Why can’t I subclass datetime.date?
  19. Extract time from datetime and determine if time (not date) falls within range?
  20. Convert string “Jun 1 2005 1:33PM” into datetime
  21. Python time to age, part 2: timezones [duplicate]
  22. How do I escape curly-brace ({}) characters in a string while using .format (or an f-string)?
  23. Which is the fastest way to extract day, month and year from a given date?
  24. Format of datetime in pyplot axis
  25. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  26. Get UTC offset from time zone name in python
  27. Python: Datetime to season
  28. finding last business day of a month in python
  29. Pandas datetimes with different formats in the same column
  30. Get weekday/day-of-week for Datetime column of DataFrame

Leave a Comment