Article 5ATMB How do I convert convert YYYYmmdd_HHMMss to datetime in linux or mysql 5.6?

How do I convert convert YYYYmmdd_HHMMss to datetime in linux or mysql 5.6?

by
cesarsj
from LinuxQuestions.org on (#5ATMB)
I cannot store, for example, 20201112_234012, in the database as datetime. This format comes from a log that I can't change in the registry, so I have to change it in bash or some mysql function to store it as datetime.latest?d=yIl2AUoC8zA latest?i=Y6-aQBL26cs:YgxC4AB-d8k:F7zBnMy latest?i=Y6-aQBL26cs:YgxC4AB-d8k:V_sGLiP latest?d=qj6IDK7rITs latest?i=Y6-aQBL26cs:YgxC4AB-d8k:gIN9vFwY6-aQBL26cs
External Content
Source RSS or Atom Feed
Feed Location https://feeds.feedburner.com/linuxquestions/latest
Feed Title LinuxQuestions.org
Feed Link https://www.linuxquestions.org/questions/
Reply 0 comments