So what seems like it should be an easy thing to do, is not always necessarily so. If you are trying to get your time information from Oracle either using DIH or the LucidWorks database crawler (which uses DIH), you may notice that you can't do that by default with either the DATE or the TIMESTAMP data types. To get it, you need to get your hands a little dirty.
First you need to edit your dataconfg.xml. For the LucidWorks crawler, this can be found in:
// Get the timestamp and convert it to a date
var timeVal = row.get("LAST_UPDATED")
var array = timeVal.split(" ");
// Put the correct date object into the original column
row.put("LAST_UPDATED", array + "T" + array + "Z");
<entity .... transformer="script:startDateTransform">
Lastly, you need to make sure you are getting timestamp information. So if you are using a TIMESTAMP type from oracle you are good. But if you are using a DATE type, then in your SQL you need to use cast to do something like this:
<entity .... query="select cast(LAST_UPDATED as TIMESTAMP) as last_updated from TEST"