SQL statement to convert date-time format in some columns

Question

I have an SQLite database in which some columns are date-time strings with the format 1/2/2000 3:45:56 am.

Is there an SQL statement which can convert these values to strings with an ISO-8601-like format (2000-01-02 03:45:56)?

(One possible non-SQL way to do this would be to export the database as a CSV file, and use Python, with its csv and datetime modules, to parse the columns.)

Answer 1

SQL As Understood By SQLite - Date And Time Functions.