« Redirect to a different URL in GWT
Listing Files with Python »

MySQL Datetime string to a Timestamp

Here is a simple function to convert a datetime string from MySQL to a UNIX timestamp using Python.

import time
# Converts an SQL datetime to a UNIX timestamp
# Example datetime: 2007-04-15 08:29:39
def sqlDateTimeToTimeStamp(sqlDateTime):
return int(time.mktime(time.strptime\
(sqlDateTime,\
“%Y-%m-%d %H:%M:%S”)))

This entry was posted on Monday, April 16th, 2007 at 5:51 pm and is filed under Python. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “MySQL Datetime string to a Timestamp”

  1. Olivio Moura Says:
    March 21st, 2008 at 4:14 pm

    from time import strptime, strftime

    olddate = ‘05:26:40 Jun 19, 2007 PST’
    newdate = strptime(” “.join(olddate.split()[:-1]), “%H:%M:%S %b %d, %Y”)
    print newdate
    mysqldate = strftime(”%Y-%m-%d %H:%M:%S”, newdate)
    print mysqldate

  2. axdkcd Says:
    April 22nd, 2008 at 8:46 am

    thanks a ton. these gems save us so much time!

Leave a Reply