Convert time format to mysql datetime format

[rouven]

Hi, i am trying to convert that time format '05:26:40 Jun 19, 2007 PDT' into mysql compatible format like YYYY-MM-DD HH:MM:SS.

the code i tried was:

from datetime import datetime
from time import strptime
f1.write("strptime(%r); locale: %r" % (olddate, locale.getlocale()))
newdate = time.strptime(olddate, "%H:%M:%S %b %d, %Y %Z")
mysqldate = time.strftime("%Y-%m-%d %H:%M:%S", newdate)
 

but i get the following error message:

newdate = time.strptime(olddate, "%H:%M:%S %b %d, %Y %Z")
File "_strptime.py", line 293, in strptime
raise ValueError("time data did not match format: data=%s fmt=%s" %
ValueError: time data did not match format: data=01:28:13 Jun 19, 2007 PDT fmt=%H:%M:%S %b %d, %Y %Z


anyone with ideas?

Regards,

Rouven

[bartonc]

Hi, i am trying to convert that time format '05:26:40 Jun 19, 2007 PDT' into mysql compatible format like YYYY-MM-DD HH:MM:SS.

the code i tried was:

from datetime import datetime
from time import strptime
f1.write("strptime(%r); locale: %r" % (olddate, locale.getlocale()))
newdate = time.strptime(olddate, "%H:%M:%S %b %d, %Y %Z")
mysqldate = time.strftime("%Y-%m-%d %H:%M:%S", newdate)
 

but i get the following error message:

newdate = time.strptime(olddate, "%H:%M:%S %b %d, %Y %Z")
File "_strptime.py", line 293, in strptime
raise ValueError("time data did not match format: data=%s fmt=%s" %
ValueError: time data did not match format: data=01:28:13 Jun 19, 2007 PDT fmt=%H:%M:%S %b %d, %Y %Z


anyone with ideas?

Regards,

Rouven

That will depend on how you get olddate. I'll try

olddate = '05:26:40 Jun 19, 2007 PDT'

[bvdet]

Hi, i am trying to convert that time format '05:26:40 Jun 19, 2007 PDT' into mysql compatible format like YYYY-MM-DD HH:MM:SS.

the code i tried was:

from datetime import datetime
from time import strptime
f1.write("strptime(%r); locale: %r" % (olddate, locale.getlocale()))
newdate = time.strptime(olddate, "%H:%M:%S %b %d, %Y %Z")
mysqldate = time.strftime("%Y-%m-%d %H:%M:%S", newdate)
 

but i get the following error message:

newdate = time.strptime(olddate, "%H:%M:%S %b %d, %Y %Z")
File "_strptime.py", line 293, in strptime
raise ValueError("time data did not match format: data=%s fmt=%s" %
ValueError: time data did not match format: data=01:28:13 Jun 19, 2007 PDT fmt=%H:%M:%S %b %d, %Y %Z


anyone with ideas?

Regards,

Rouven

The time zone information is dependent on the value stored in time.tzname. On my machine it is 'Central Daylight Time'. Try 'Pacific Daylight Time' on your machine. This is from Python 2.3 docs:

The use of %Z is now deprecated, but the %z escape that expands to the preferred hour/minute offset is not supported by all ANSI C libraries.

[bartonc]

The time zone information is dependent on the value stored in time.tzname. On my machine it is 'Central Daylight Time'. Try 'Pacific Daylight Time' on your machine. This is from Python 2.3 docs:

The use of %Z is now deprecated, but the %z escape that expands to the preferred hour/minute offset is not supported by all ANSI C libraries.

Great info, BV. I had discovered that it was the zone which was not being parsed.
So I stripped it off:

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
 

[bartonc]

The time zone information is dependent on the value stored in time.tzname. On my machine it is 'Central Daylight Time'. Try 'Pacific Daylight Time' on your machine. This is from Python 2.3 docs:

The use of %Z is now deprecated, but the %z escape that expands to the preferred hour/minute offset is not supported by all ANSI C libraries.

I actually get a tuple:

from time import tzname
 
print tzname

('Pacific Standard Time', 'Pacific Daylight Time')

Oh, joy: more stuff to learn!

[rouven]

thank you for your help, now it works but i have to convert the timezone before writing it to the database.