Convert string to datetime mysql

Hi, You can use convert() function probably once you are doing in db.one more thing you can do is, Before dumping it to db table , format the column as well into date time from string. In this case you wont have to convert in DB.

Can you clarify - do you need to do this conversion in SQL itself or can it be converted in Appian before being passed to the DB?  If it can be parsed in Appian, it would be pretty straightforward to build a parser rule that breaks up the timestamp string into component parts and feeds it into a rule like "datetime()", and returns an Appian Date/Time value.