time data does not match format

by

You have the month and day swapped:

'%m/%d/%Y %H:%M:%S.%f'

28 will never fit in the range for the %m month parameter otherwise.

With %m and %d in the correct order parsing works:

>>> from datetime import datetime
>>> datetime.strptime('07/28/2014 18:54:55.099000', '%m/%d/%Y %H:%M:%S.%f')
datetime.datetime(2014, 7, 28, 18, 54, 55, 99000)

You don’t need to add '000'; %f can parse shorter numbers correctly:

>>> datetime.strptime('07/28/2014 18:54:55.099', '%m/%d/%Y %H:%M:%S.%f')
datetime.datetime(2014, 7, 28, 18, 54, 55, 99000)

More Related Contents:

  1. Converting between datetime, Timestamp and datetime64
  2. Iterating through a range of dates in Python
  3. How to construct a timedelta object from a simple string
  4. Combine Date and Time columns using python pandas
  5. Parsing date with timezone from an email?
  6. How to increment datetime by custom months in python without using library [duplicate]
  7. Can’t subtract offset-naive and offset-aware datetimes
  8. Convert datetime to Unix timestamp and convert it back in python
  9. How to increment a datetime by one day?
  10. Datetime Timezone conversion using pytz
  11. How to read datetime back from sqlite as a datetime instead of string in Python?
  12. How to get current time in python and break up into year, month, day, hour, minute?
  13. Fetching datetime from float in Python
  14. “import datetime” v.s. “from datetime import datetime”
  15. How do you convert a datetime/timestamp from one timezone to another timezone?
  16. How to convert to a Python datetime object with JSON.loads?
  17. Why does datetime.datetime.utcnow() not contain timezone information?
  18. Convert a column of datetimes to epoch in Python
  19. How to define format when using pandas to_datetime?
  20. pd.Timestamp versus np.datetime64: are they interchangeable for selected uses?
  21. pandas bar plot combined with line plot shows the time axis beginning at 1970
  22. how to test if a variable is pd.NaT?
  23. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  24. How to create a DateTime equal to 15 minutes ago?
  25. Formatting “yesterday’s” date in python
  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. Python strptime parsing year without century: assume prior to this year?
  30. Get weekday/day-of-week for Datetime column of DataFrame

Leave a Comment