Convert a Orace timestamp to a datetime you can use in an hsqldb

Here's how you can convert a timestamp column in an ORACLE DB into a string you can use as a datetime in an INSERT statement in HSQLDB.

select to_char(current_timestamp, 'yyyy-mm-dd hh24:mi:ss.ff9') from dual;