Converting Epoch time into the datetime

Question

I am getting a response from the rest is an Epoch time format like  start time   1234566 end time   1234578   I want to convert that epoch seconds in MySQL format time so that I could store the differences in my MySQL database   I tried    gt  gt  gt  import time  gt  gt  gt  time gmtime 123456  time struct time tm year 1970  tm mon 1  tm mday 2  tm hour 10  tm min 17  tm sec 36  tm wday 4  tm yday 2  tm isdst 0    The above result is not what I am expecting  I want it be like   2012-09-12 21 00 00   Please suggest how can I achieve this   Also  Why I am getting TypeError  a float is required for   gt  gt  gt  getbbb class end time   1347516459425  gt  gt  gt  mend   time gmtime getbbb class end time  tm hour Traceback  most recent call last         TypeError  a float is required

User · Answer

Try this    gt  gt  gt  import time  gt  gt  gt  time strftime   Y- m- d  H  M  S   time gmtime 1347517119    2012-09-12 23 18 39    Also in MySQL  you can FROM UNIXTIME like   INSERT INTO tblname VALUES  FROM UNIXTIME 1347517119     For your 2nd question  it is probably because getbbb class end time is a string   You can convert it to numeric like  float getbbb class end time

User · Answer

You can also use datetime    gt  gt  gt  import datetime  gt  gt  gt  datetime datetime fromtimestamp 1347517370  strftime   c      2012-09-13 02 22 50

User · Answer

First a bit of info in epoch from man gmtime  The ctime    gmtime   and localtime   functions all take an argument of data type time t which represents calendar  time    When  inter-        preted  as  an absolute time value  it represents the number of seconds elapsed since 00 00 00 on January 1  1970  Coordinated Universal        Time  UTC     to understand how epoch should be    gt  gt  gt  time time   1347517171 6514659  gt  gt  gt  time gmtime time time     2012  9  13  6  19  34  3  257  0    just ensure the arg you are passing to time gmtime   is integer

User · Answer

gt  gt  gt  import datetime  gt  gt  gt  datetime datetime fromtimestamp 1347517370  strftime   Y- m- d  H  M  S    2012-09-13 14 22 50    Local time   To get UTC    gt  gt  gt  datetime datetime utcfromtimestamp 1347517370  strftime   Y- m- d  H  M  S      2012-09-13 06 22 50

User · Answer

If you have epoch in milliseconds a possible solution is convert to seconds  import time time ctime milliseconds 1000   For more time functions  https   docs python org 3 library time html functions

User · Answer

This is what you need  In  1   time time   Out 1   1347517739 44904  In  2   time strftime   Y- m- d  H  M  S   time gmtime time time     Out 2    2012-09-13 06 31 43    Please input a float instead of an int and that other TypeError should go away   mend   time gmtime float getbbb class end time   tm hour

User · Answer

To convert your time value  float or int  to a formatted string  use   time strftime   Y- m- d  H  M  S   time localtime 1347517370

User · Answer

This adds 10 seconds from now  from datetime import datetime import commands  date string command  date   s  utc   commands getoutput date string command  a date datetime fromtimestamp float int utc    strftime   Y- m- d  H  M  S   print  a date   a date  utc   int utc  10 b date datetime fromtimestamp float utc   strftime   Y- m- d  H  M  S   print  b date   b date    This is a little more wordy but it comes from date command in unix

[python] Converting Epoch time into the datetime

Examples related to python