Python: Sql result with Unix time into seconds

Question

I have following query,

SELECT UNIX_TIMESTAMP() - UNIX_TIMESTAMP(rc_timestamp) AS LAG_TIME FROM recentchanges ORDER BY rc_timestamp DESC LIMIT 1

In my python code I am trying to get it to convert into seconds, but what I am currently getting is following:

{'LAG_TIME': 32L}

I tried with utf but results is same.

getLagTime = ur"""SELECT UNIX_TIMESTAMP() - UNIX_TIMESTAMP(rc_timestamp) AS LAG_TIME FROM recentchanges ORDER BY rc_timestamp DESC LIMIT 1"""
cursor.execute(getLagTime)
lagTime = cursor.fetchall()
for time in lagTime:
    print time
    print unicode(time['LAG_TIME'], 'utf-8', error='strict')

I updated the code, its a tiny fraction of a very lengthy code. — add-semi-colons
– add-semi-colons, Commented Feb 10, 2012 at 17:50

guettli · Accepted Answer · 2012-02-10 07:53:32Z

3

I guess you already have the answer: 32 seconds. Don't get confused by the "L". It tells you, that this is a long value, and not an int.

answered Feb 10, 2012 at 7:53

guettli

27.6k109 gold badges423 silver badges779 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python: Sql result with Unix time into seconds

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related