Is it known behavior that when using RCP with the Oracle Connector to select a table with Oracle DATE types, which contain dates AND times, that you lose the time portion? The jobs go from the Connector to a Data Set. When I dump the Data Set to a text file, or just view the Data Set, only the date portion is there. We are losing time!
![Shocked :shock:](./images/smilies/icon_eek.gif)
We do have the following setting set inside our dsenv file on the server:
NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
Also when I view data from the Connector, it does not honor the specified format we have in the dsenv file. It only displays the date portion.
But if I go and view the same data via Oracle SQL Developer then I can see all the dates AND times.
Is there a setting to enable to allow us to retain the time portion? I had some trouble searching on a solution.
On a related note, is the DSXchange "Search for all terms" function no longer working? I searched on all terms "oracle date RCP" and got no results, yet google pointed me to multiple results. Example: viewtopic.php?p=401272