Hallo, >: I have a field with the type TIMESTAMP(6) in an oracle view. > ... >: What is the best way to import it? > ... >: This way works but I do not know if this is the best practise: > ... >: TO_CHAR(LAST_ACTION_TIMESTAMP, 'YYYY-MM-DD HH24:MI:SS') as >: LAT > > instead of having your DB convert to a string, and then forcing DIH to > parse that string, try asking your DB to cast to something that JDBC > will respect as a Date object when DIH fetches the results > > I don't know much about oracle, but perhaps something like... > > SELECT ... CAST(LAST_ACTION_TIMESTAMP AS DATE) AS LAT
This removes the time part of the timestamp in SOLR. althought it is shown in PL/SQL-Developer (Tool for Oracle). The only way I found in the net is to write an own converter :-( Thanks in advance for any other hints. Ciao Peter Schütt
