I have the following format:
"Wed Jun 25 15:38:29 PDT 2014" and I would like to convert it to "2014-06-25 15:38:29", i.e. "%Y-%m-%d %H:%M:%S"
Code:
import time
import datetime
rawtime = "Wed Jun 25 15:38:29 PDT 2014"
dt = time.strptime(rawtime, "%Y-%m-%d %H:%M:%S")
print dt
I get the error:
ValueError: time data 'Wed Jun 25 15:38:29 PDT 2014\n' does not match format '%Y-%m-%d %H:%M:%S'
Simplest solution using dateutil package. It really is excellent at this.
from dateutil import parser
print parser.parse("Wed Jun 25 15:38:29 PDT 2014")
Output:
2014-06-25 15:38:29
First install pytz:
sudo easy_install --upgrade pytz
Then
import datetime
from pytz import timezone
rawtime = "Wed Jun 25 15:38:29 PDT 2014"
d = datetime.datetime.strptime(rawtime,'%a %b %d %H:%M:%S %Z %Y')
print(d.strftime("%Y-%m-%d %H:%M:%S"))
Should return:
2014-06-25 15:38:29
Just get rid of the PDT part:
import time
import datetime
rawtime = "Wed Jun 25 15:38:29 PDT 2014"
times = rawtime.split(' ')
del times[4]
dt = time.strptime(' '.join(times), '%a %b %d %H:%M:%S %Y')
print time.strftime("%Y-%m-%d %H:%M:%S", dt)
Should get you:
2014-06-25 15:38:29
pip install python-dateutil:
In [56]: from dateutil import parser
In [57]: parser.parse("Wed Jun 25 15:38:29 PDT 2014").strftime("%Y-%m-%d %H:%M:%S")
Out[57]: '2014-06-25 15:38:29'
Or manually:
In [58]: d = time.strptime("Wed Jun 25 15:38:29 PDT 2014","%a %b %d %H:%M:%S PDT %Y")
In [59]: "{}-{:02}-{:02} {:02}:{:02}:{:02}".format(d.tm_year,d.tm_mon,d.tm_mday,d.tm_hour,d.tm_min,d.tm_sec)
Out[59]: '2014-06-25 15:38:29'
Usually you need to call strptime or use dateutil to parse date strings. However in this case, rawtime looks similar enough to a date as specified by the RFC 2822 (Internet Message Format) that it can parsed using the standard library function email.utils.parsedate:
import email.utils as EU
import datetime as DT
rawtime = "Wed Jun 25 15:38:29 PDT 2014"
timetup = EU.parsedate(rawtime)
# (2014, 6, 25, 15, 38, 29, 0, 1, -1)
date = DT.datetime(*timetup[:6])
print(date)
# 2014-06-25 15:38:29
Hey So i found a solution for 95% of your problem.
import time
import datetime
rawtime = "Wed Jun 25 15:38:29 2014"
dt = time.strptime("%a %b %d %H:%M:%S %Y",rawtime)
print dt
this will out time.struct_time(tm_year=2014, tm_mon=6, tm_mday=25, tm_hour=15, tm_min=38, tm_sec=29, tm_wday=2, tm_yday=176, tm_isdst=-1)
After this you just need to create a string and place them in the right order you want. The only thing I wasn't sure of how to do off the top of my head was the PDT part of it.
To save the dt as a variable you can do
x = str(dt.tm_year) + "-" + str(dt.tm_mon) + "-" + str(dt.tm_mday) + " " + str(dt.tm_hour) + ":" + str(dt.tm_min) + ":" + str(dt.tm_sec)
print x
this will output 2014-6-25 15:38:29
Good luck!
x = str(dt.tm_year) + "-" + str(dt.tm_mon) + "-" + str(dt.tm_mday) + " " + str(dt.tm_hour) + ":" + str(dt.tm_min) + ":" + str(dt.tm_sec) hope that helps!
strptime, not the format you want it to be!