lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Hostetter <hossman_luc...@fucit.org>
Subject Re: Oracle Timestamp in SOLR
Date Thu, 16 May 2013 17:00:09 GMT

: >      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

Mime
View raw message