Convert string to datetime mysql

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.

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.

Thanks , I want to do at DB side as I am using CSV import smart service to import all the data in siting format

I assume there might be SQL functionality that can handle this, though it might be quite a bit harder.  That question might be best answered by looking into external SQL reference sites, though.