'oracle insert o into timestamp column

I am having a csv file which contains 0 in timestamp column in source , when it is being inserted into oracle through informatica it is populated as NULL values. I am not sure whether this is correct . whether it should be 0 or NULL or any other value. Could anyone confirm on this.

sqloracleetlinformatica-powercenterflat-file


Solution 1:[1]

This is the expected behavior, as ORACLE can't store 0 in a timestamp column.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Novneet

Related Questions