Hello, I intend import data from Oracle to H2 with linked tables, but when I import a date from Oracle (with format datetime), in H2 only recive format date with "0" in time.
I put the type of field in H2 to "DATETIME" and in the console shows "TimesTamp(23,10)", but in the linked table of Oracle appears "DATE(8)". If make a "select" of linked table appears whit the time with "0". This is the import process: DROP TABLE IF EXISTS INICIO; create table INICIO (FECHA DATETIME); create linked table INICIO_ORA(null, 'jdbc:oracle:thin:@x.x.x.x:x:pid', 'user', 'pass', 'INICIO'); insert into INICIO select * from INICIO_ORA; DROP TABLE INICIO_ORA; The table "INICIO" in Oracle has only a filed named "FECHA" and type "DATE", and exists value from time in. Can you help me ? Thanks. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
