datetime: Round/trim number of digits in microseconds

by

The simplest way would be to use slicing to just chop off the last three digits of the microseconds:

def format_time():
    t = datetime.datetime.now()
    s = t.strftime('%Y-%m-%d %H:%M:%S.%f')
    return s[:-3]

I strongly recommend just chopping. I once wrote some logging code that rounded the timestamps rather than chopping, and I found it actually kind of confusing when the rounding changed the last digit. There was timed code that stopped running at a certain timestamp yet there were log events with that timestamp due to the rounding. Simpler and more predictable to just chop.

If you want to actually round the number rather than just chopping, it’s a little more work but not horrible:

def format_time():
    t = datetime.datetime.now()
    s = t.strftime('%Y-%m-%d %H:%M:%S.%f')
    head = s[:-7] # everything up to the '.'
    tail = s[-7:] # the '.' and the 6 digits after it
    f = float(tail)
    temp = "{:.03f}".format(f)  # for Python 2.x: temp = "%.3f" % f
    new_tail = temp[1:] # temp[0] is always '0'; get rid of it
    return head + new_tail

Obviously you can simplify the above with fewer variables; I just wanted it to be very easy to follow.

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. Convert timedelta to years?
  10. Find the closest date to a given date
  11. How to increment a datetime by one day?
  12. Datetime Timezone conversion using pytz
  13. How to read datetime back from sqlite as a datetime instead of string in Python?
  14. How to get current time in python and break up into year, month, day, hour, minute?
  15. Fetching datetime from float in Python
  16. “import datetime” v.s. “from datetime import datetime”
  17. How do you convert a datetime/timestamp from one timezone to another timezone?
  18. How to convert to a Python datetime object with JSON.loads?
  19. Why does datetime.datetime.utcnow() not contain timezone information?
  20. Convert a column of datetimes to epoch in Python
  21. How to define format when using pandas to_datetime?
  22. pd.Timestamp versus np.datetime64: are they interchangeable for selected uses?
  23. pandas bar plot combined with line plot shows the time axis beginning at 1970
  24. how to test if a variable is pd.NaT?
  25. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  26. How to create a DateTime equal to 15 minutes ago?
  27. Convert a column of timestamps into periods in pandas
  28. Python: Adding hours to pandas timestamp
  29. how to specify the datetime format in read_csv
  30. Python generating a list of dates between two dates

Leave a Comment