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