How to convert datetime to integer in python

Question

how can i convert YYYY-MM-DD hh mm ss format to integer in python  for example 2014-02-12 20 51 14 -  to integer   i know how to convert only hh mm ss but not yyyy-mm-dd hh mm ss  def time to num time str       hh  mm   ss   map int  time str split           return ss   60  mm   60 hh

User · Accepted Answer

It depends on what the integer is supposed to encode. You could convert the date to a number of milliseconds from some previous time. People often do this affixed to 12:00 am January 1 1970, or 1900, etc., and measure time as an integer number of milliseconds from that point. The datetime module (or others like it) will have functions that do this for you: for example, you can use int(datetime.datetime.utcnow().timestamp()).

If you want to semantically encode the year, month, and day, one way to do it is to multiply those components by order-of-magnitude values large enough to juxtapose them within the integer digits:

2012-06-13 --> 20120613 = 10,000 * (2012) + 100 * (6) + 1*(13)

def to_integer(dt_time):
    return 10000*dt_time.year + 100*dt_time.month + dt_time.day

E.g.

In [1]: import datetime

In [2]: %cpaste
Pasting code; enter '--' alone on the line to stop or use Ctrl-D.
:def to_integer(dt_time):
:    return 10000*dt_time.year + 100*dt_time.month + dt_time.day
:    # Or take the appropriate chars from a string date representation.
:--

In [3]: to_integer(datetime.date(2012, 6, 13))
Out[3]: 20120613

If you also want minutes and seconds, then just include further orders of magnitude as needed to display the digits.

I've encountered this second method very often in legacy systems, especially systems that pull date-based data out of legacy SQL databases.

It is very bad. You end up writing a lot of hacky code for aligning dates, computing month or day offsets as they would appear in the integer format (e.g. resetting the month back to 1 as you pass December, then incrementing the year value), and boiler plate for converting to and from the integer format all over.

Unless such a convention lives in a deep, low-level, and thoroughly tested section of the API you're working on, such that everyone who ever consumes the data really can count on this integer representation and all of its helper functions, then you end up with lots of people re-writing basic date-handling routines all over the place.

It's generally much better to leave the value in a date context, like datetime.date, for as long as you possibly can, so that the operations upon it are expressed in a natural, date-based context, and not some lone developer's personal hack into an integer.

User · Answer

I think I have a shortcut for that     Importing datetime  from datetime import datetime    Creating a datetime object so we can test  a   datetime now      Converting a to string in the desired format  YYYYMMDD  using strftime   and then to int  a   int a strftime   Y m d

User · Answer

This in an example that can be used for example to feed a database key  I sometimes use instead of using AUTOINCREMENT options   import datetime   dt   datetime datetime now   seq   int dt strftime   Y m d H M S

User · Answer

When converting datetime to integers one must keep in mind the tens  hundreds and thousands     like  2018-11-03  must be like 20181103 in int for that you have to  2018 10000   100  11   3  Similarly another example   2018-11-03 10 02 05  must be like 20181103100205 in int  Explanatory Code  dt   datetime 2018 11 3 10 2 5  print  dt    print  dt timestamp      unix representation     not useful when converting to int  print  dt strftime   Y- m- d    print  dt year 10000   dt month  100    dt day  print  int dt strftime   Y m d      print  dt strftime   Y- m- d  H  M  S    print  dt year 10000000000   dt month  100000000  dt day   1000000   dt hour 10000     dt minute 100   dt second  print  int dt strftime   Y m d H M S       General Function  To avoid that doing manually use below function  def datetime to int dt       return int dt strftime   Y m d H M S

[python] How to convert datetime to integer in python

Examples related to python

Examples related to datetime

Examples related to integer

Examples related to converter