INSERT into DB DateTime string

Question

I have the string 04/04/2012 04:03:35 AM. How can I convert it and insert into a table? Field type is datetime.

Downvoters care to explain? It's a perfectly valid question. — eggyal
– eggyal, Commented May 10, 2012 at 17:38
@eggyal Please refer to the stackoverflow.com/questions/how-to-ask, i am sure there is a clause there that say provide example of what you have tried first and make sure you search for your answer prior to asking, such as stackoverflow.com/questions/3296725/parse-date-in-mysql — Churk
– Churk, Commented May 10, 2012 at 22:11

eggyal · Accepted Answer · 2012-05-10 17:35:24Z

23

You need to use STR_TO_DATE():

STR_TO_DATE('04/04/2012 04:03:35 AM', '%d/%m/%Y %r')

Or, better yet, present your literal in a format MySQL expects (e.g. YYYY-MM-DD HH:mm).

answered May 10, 2012 at 17:35

eggyal

127k18 gold badges220 silver badges244 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1