Hallo, > >: > 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). > > Hmmm... that makes no sense to me based on 10 seconds of googling... > > http://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#i184 > 7 > > "The DATE datatype stores the year (including the century), the month, > the day, the hours, the minutes, and the seconds" > > ...but i'll take your word for it. > >: The only way I found in the net is to write an own converter :-( > > There must be *some* way to either tweak your SQL or tweak your JDBC > connection properties such that Oracle's JDBC driver will give you a > legitimate java.sql.Date or java.sql.Timestamp instead of it's own > internal class (that doesn't extend java.util.Date) ... otherwise it's > just total freaking anarchy.
Perhaps it is really an oracle problem. I found also this solution: http://stackoverflow.com/questions/10111517/getting-correct-time-from- oracle-date-in-solr-dataimporthandler but I did not get it to run. So I keep my timestamp - string - date way (which I do not really like). Ciao Peter Schütt
