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 · 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"))

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

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

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

[python] How to convert datetime to integer in python

Explanatory Code

General Function

Examples related to python

Examples related to datetime

Examples related to integer

Examples related to converter