[SOLVED] python datetime to epoch

divyashree · 09-25-2014, 02:41 AM

I have a dattime object in following format:

Code:

%Y-%m-%d %H:%M:%S

How can I convert it to epoch seconds.

I am trying to convert like this :

Code:

epoch_start = time.mktime(time.strptime(i, "%Y-%m-%d %H:%M:%S"));

Here

Code:

holds the value :

Code:

2014-09-26 12:24:23

But its throwing error:

Code:

Traceback (most recent call last):
  File "test1.py", line 29, in <module>
    epoch_start = time.mktime(time.strptime(i, "%Y-%m-%d %H:%M:%S"));
  File "C:\Python27\lib\_strptime.py", line 467, in _strptime_time
    return _strptime(data_string, format)[0]
  File "C:\Python27\lib\_strptime.py", line 322, in _strptime
    found = format_regex.match(data_string)
TypeError: expected string or buffer

weibullguy · 09-25-2014, 08:07 AM

Probably because i is a datetime object not a string or buffer. If you want to convert a python datetime to seconds since epoch you should do it explicitly:

Code:

from datetime import datetime

epoch = datetime.datetime(1970,1,1)
i = datetime.now()

delta_time = (i - epoch).total_seconds()

divyashree · 09-25-2014, 08:17 AM

Quote:

Originally Posted by weibullguy

Probably because i is a datetime object not a string or buffer. If you want to convert a python datetime to seconds since epoch you should do it explicitly:

Code:

i = datetime.now()

Thanks weibullguy for the response. The problem is that I am getting the value of i from database after query, in the format as I mentioned.

So I cant use datetime.now().

The value of i varries as stored in database.

weibullguy · 09-25-2014, 08:35 AM

I was only using datetime.now() for the example. As long as i is a datetime object, which you state it is in your original post, the remainder of the code will calculate the total number of seconds since epoch.

divyashree · 09-25-2014, 08:52 AM

Quote:

Originally Posted by weibullguy

I was only using datetime.now() for the example. As long as i is a datetime object, which you state it is in your original post, the remainder of the code will calculate the total number of seconds since epoch.

Your code is throwing error:

Code:

Traceback (most recent call last):
  File "test2.py", line 5, in <module>
    epoch = datetime.datetime(1970,1,1)
AttributeError: type object 'datetime.datetime' has no attribute 'datetime'

weibullguy · 09-25-2014, 08:56 AM

Sorry. One too many datetime in the epoch line. Try this...

Code:

from datetime import datetime

epoch = datetime(1970,1,1)
i = datetime.now()

delta_time = (i - epoch).total_seconds()

dugan · 09-25-2014, 09:46 AM

I don't know how accurate it is, but this is something that came up in a Google search:

Code:

>>> import datetime
>>> import time
>>> time.mktime(datetime.datetime.now().timetuple())
1411656461.0

Critique?

There were many other hits, including this thread:

http://stackoverflow.com/q/6999726

divyashree · 10-01-2014, 01:41 AM

I got the epoch value by :

Quote:

import time
import calendar

start_epoch = int(round(time.mktime(row[3].timetuple())))

Thanks all for your responses.