Help, can not create new Topic

On 7/5 i upgraded VI to 9.4.1.2
Since 7/5 Oracle source DATE columns no longer display TIME in the source data grid.
Tried several things, can not get records to insert now with time, only date.

Only way to show TIME is using TO_CAHR() in the source data grid, but that does not work, can not insert CHAR

We are looking at it now

In grid, date = 'dd-mmm-yy'
I can get time to show in grid with to_char(EVENT_DATE, 'MM-DD-YYYY HH:MI AM') EVENT_DATE

But to insert into Oracle DATE filed i have to convert back to TO_DATE()

When i use this, the time goes away in source data grid
to_date(to_char(EVENT_DATE, 'MM-DD-YYYY HH:MI AM') ,'MM-DD-YYYY HH:MI AM')     EVENT_DATE,

Think I'm proving to myself the Visual Importer Source data grid is stripping out TIME from Oracle DATE datatype unless it is in CHAR format

We have found a way around it,

I suggest a have a remote session tomorrow if you have time
 

you have time this afternoon? Can send you teams meeting for 15 minutes.
I have nearly 100 tables without timestamp since 7/5.
or throw me the work around idea best you can and I'll do some testing.

Can you reach out to me soon as you can tomorrow.
11 days of production data is missing and i have reports and outputs too numerious to count with missing data.