In order to convert an Enscribe Timestamp within your SQL statement you can use the following syntax:

select
dateadd(second,substr(ts_column,1,12) - 210235608000,to_date('1950-01-01 00:00:00')) as the_converted_timestamp

This will convert the timestamp for dates after 1950-01-01.

If you need the fractional part of the seconds then you can use:
substr(ts_column,13)