As well known, in Oracle a DATE column is a TIMESTAMP column without fractional seconds info.
Replicating, with SymmetricDS, an Oracle table with a DATE column into a H2 DB I get a (formally) perfect copy of my original table.
Unfortunately in H2 the DATE datatype is the ANSI DATE datatype with only century+year+month+day info, so when SymmetricDS transfers data from Oracle to H2 the time part of my datetime values goes lost.... :S
The most obvious solution is to change, on the Oracle's side, all DATE fields to TIMESTAMP but what else could I do, if I could, without changing the Oracle DB.....?
Thanks in advance

 
Last edit: Alessandro Pellegrini 2014-07-11