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
On 5/16/2013 11:00 AM, Chris Hostetter wrote:
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.
: > 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
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, '-MM-DD HH24:MI:SS') as
>: LAT
: 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, '-MM-DD HH24:MI:SS') as LAT
instead of having your D
Peter,
Looks like you can call timestampValue() on that object and get back a
java.sql.Timestamp, which is a subclass of java.util.Date:
http://docs.oracle.com/cd/E16338_01/appdev.112/e13995/oracle/sql/TIMESTAMP.html#timestampValue__
Hope that helps,
Michael Della Bitta
Hallo,
I have a field with the type TIMESTAMP(6) in an oracle view.
When I want to import it directly to SOLR I get this error message:
WARNING: Error creating document : SolrInputDocument[oid=12,
last_action_timestamp=oracle.sql.TIMESTAMP@34907781, status=2, ...]
org.apache.solr.common.SolrExc
