Converting string to datetime object

by

To parse the date in RFC 2822 format, you could use email package:

from datetime import datetime, timedelta
from email.utils import parsedate_tz, mktime_tz

timestamp = mktime_tz(parsedate_tz("Thu, 16 Oct 2014 01:16:17 EDT"))
# -> 1413436577
utc_dt = datetime(1970, 1, 1) + timedelta(seconds=timestamp)
# -> datetime.datetime(2014, 10, 16, 5, 16, 17)

Note: parsedate_tz() assumes that EDT corresponds to -0400 UTC offset but it might be incorrect in Australia where EDT is +1100 (AEDT is used by pytz in this case) i.e., a timezone abbreviation may be ambiguous. See Parsing date/time string with timezone abbreviated name in Python?

Related Python bug: %Z in strptime doesn’t match EST and others.

If your computer uses POSIX timestamps (likely), and you are sure the input date is within an acceptable range for your system (not too far into the future/past), and you don’t need to preserve the microsecond precision then you could use datetime.utcfromtimestamp:

from datetime import datetime
from email.utils import parsedate_tz, mktime_tz

timestamp = mktime_tz(parsedate_tz("Thu, 16 Oct 2014 01:16:17 EDT"))
# -> 1413436577
utc_dt = datetime.utcfromtimestamp(timestamp)
# -> datetime.datetime(2014, 10, 16, 5, 16, 17)

More Related Contents:

  1. Converting datetime.date to UTC timestamp in Python
  2. Format timedelta to string
  3. How to convert local time string to UTC?
  4. Filtering Pandas DataFrames on dates
  5. How to print pandas DataFrame without index
  6. Converting string with UTC offset to a datetime object [duplicate]
  7. How do I convert a datetime to date?
  8. Trying to mock datetime.date.today(), but not working
  9. Most recent previous business day in Python
  10. Convert string date to timestamp in Python
  11. Getting today’s date in YYYY-MM-DD in Python?
  12. type object ‘datetime.datetime’ has no attribute ‘datetime’
  13. How to change the datetime tick label frequency for matplotlib plots
  14. python – datetime with timezone to epoch
  15. Python speed testing – Time Difference – milliseconds
  16. What exactly does the T and Z mean in timestamp?
  17. How to get UTC time in Python?
  18. Date difference in minutes in Python
  19. Parameter unsupported when inserting int
  20. In Pandas how do I convert a string of date strings to datetime objects and put them in a DataFrame?
  21. Locate first and last non NaN values in a Pandas DataFrame
  22. Format of datetime in pyplot axis
  23. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  24. Formatting “yesterday’s” date in python
  25. Get UTC offset from time zone name in python
  26. Python: Datetime to season
  27. finding last business day of a month in python
  28. Python strptime parsing year without century: assume prior to this year?
  29. Pandas datetimes with different formats in the same column
  30. Get weekday/day-of-week for Datetime column of DataFrame

Leave a Comment