Convert a mysql date or time to a datetime you can use in an hsqldb

Here is how to convert a mysql date or time to a datetime you can use in an hsqldb INSERT statement.

select date_format(name_of_date_column, '%Y-%m-%d %H:%i:%s') from table_containing_date_column