: > 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#i1847 "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. -Hoss
