vendredi 28 novembre 2014

Converting string to date with timezone adjustment


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