python - Unable to convert or understand dates in strange format -

i converting bunch of dates in database unixtimestamp in python. there entries in database written like:

thu jun 16 10%3a08%3 wed jun 8 09%3a39%3a 

can 1 tell me means? , possibly how convert on unixtimestamp?

any other dates such as: thu oct 14 15:11:47 use strptime convert over, ones above giving me issue.

thanks!

the '%3a' bits url encoded representation of colon :. can use urllib.unquote() function decode strings:

>>> urllib.unquote("wed jun 8 09%3a39%3a") 'wed jun 8 09:39:'  

...but looks dates got stored in fixed-length field , seconds have been truncated.