Fetching datetime from float in Python

by

Looks like an Excel datetime format, called serial date. Quick and dirty way to convert it:

>>> import datetime
>>> serial = 43111.0
>>> seconds = (serial - 25569) * 86400.0
>>> datetime.datetime.utcfromtimestamp(seconds)
datetime.datetime(2018, 1, 11, 0, 0)

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. Converting string with UTC offset to a datetime object [duplicate]
  6. Trying to mock datetime.date.today(), but not working
  7. Most recent previous business day in Python
  8. type object ‘datetime.datetime’ has no attribute ‘datetime’
  9. How to change the datetime tick label frequency for matplotlib plots
  10. python – datetime with timezone to epoch
  11. Python speed testing – Time Difference – milliseconds
  12. What exactly does the T and Z mean in timestamp?
  13. Comparing two date strings in Python
  14. Difference between Python datetime vs time modules
  15. Natural/Relative days in Python
  16. Why can’t I subclass datetime.date?
  17. Extract time from datetime and determine if time (not date) falls within range?
  18. Convert string “Jun 1 2005 1:33PM” into datetime
  19. Python time to age, part 2: timezones [duplicate]
  20. Python pandas convert datetime to timestamp effectively through dt accessor
  21. Which is the fastest way to extract day, month and year from a given date?
  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. How to convert Python’s .isoformat() string back into datetime object [duplicate]
  25. Why does “%-d”, or “%-e” remove the leading space or zero?
  26. Python summing up time
  27. Ceil a datetime to next quarter of an hour
  28. Clean way to convert quarterly periods to datetime in pandas
  29. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  30. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13

Leave a Comment