Convert SQL Datatime using python

Question

I have a query that returns a date time in sql, example:

+---------------------+
| created             |
+---------------------+
| 2008-07-31 21:42:52 |
+---------------------+

In my python code I am doing the following to capture the data by calling the query. Here is my python code:

query_item_created_f = None
                    query_item_created_f = query_item_created.format(parent_id=question_id)
                    self.dbCursor.execute(query_item_created_f)
                    created_date = self.dbCursor.fetchall()
                    print created_date

I get the data and time in following format:

({'created': datetime.datetime(2008, 7, 31, 21, 42, 52)},)

How can I change this to unix data time?

Martijn Pieters · Accepted Answer · 2013-02-01 21:28:01Z

2

Call the .timetuple() method on the datetime.datetime object, pass that to time.mktime() to create a UNIX timestamp:

>>> import datetime
>>> dt = datetime.datetime(2008, 7, 31, 21, 42, 52)
>>> import time
>>> time.mktime(dt.timetuple())
1217533372.0

answered Feb 1, 2013 at 21:28

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

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

4 Comments

add-semi-colons Over a year ago

dt = datetime.datetime(int(created_date)) TypeError: int() argument must be a string or a number, not 'tuple I am getting this error, I cast it to int just like this: print created_date dt = datetime.datetime(int(created_date)) unix_time = time.mktime(dt.timetuple()

add-semi-colons Over a year ago

problem is my date is in following format 2008-07-31 21:42:52 and according to your example I need to separate them to integers.

Martijn Pieters Over a year ago

No, you showed that your database returns a datetime.datetime() object already; in my example I recreate the same object so that I can call the .timetuple() method on it. You do not need to do the same.

Martijn Pieters Over a year ago

In other words, use print time.mktime(created_time[0]['created'].timetuple())

bonCodigo · Accepted Answer · 2013-02-01 21:27:04Z

0

Try with strftime:

'datetime.datetime(2008, 7, 31, 21, 42, 52).strftime('%Y-%m-%d %H:%M:%S')

answered Feb 1, 2013 at 21:27

bonCodigo

14.4k1 gold badge52 silver badges93 bronze badges

2 Comments

Martijn Pieters Over a year ago

That's not a UNIX time value (seconds since the epoch).

bonCodigo Over a year ago

seconds since the epoch the catch :)

Collectives™ on Stack Overflow

Convert SQL Datatime using python

2 Answers 2

4 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related