I am attempting to convert stirngs to dates in mysql
Thu Oct 23 16:46:47 2014 +02:00
Im unsure how to handle the +02:00, The rest is simple enough
update logs
set date = str_to_date(date_raw, '%a %b %e %T %Y')
This returns
Truncated incorrect datetime value: 'Thu Oct 23 16:46:47 2014 +02:00'
Any ideas?
Aucun commentaire:
Enregistrer un commentaire