oracle insert o into timestamp column

Question

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.

0 doesn't represent a timestamp, what would you suggest it does other than giving NULL? An error is all I can imagine — HoneyBadger
– HoneyBadger, Commented Mar 31, 2022 at 13:41
And exactly what "time" (actually, date/time) would you expect the simple numeric value of zero to represent? — EdStevens
– EdStevens, Commented Mar 31, 2022 at 14:35
@EdStevens - when it all started :) - big bang time may be. @abirami - Jokes apart, this is expected behavior from informatica. You can use a logic like this IIF(col=0, null, col) to replace 0 with null or you cna use sysdate too or any default date. — Koushik Roy
– Koushik Roy, Commented Mar 31, 2022 at 14:42
Do you want the year 0 to be 1900, 1970 or the year you were born? — user18098820
– user18098820, Commented Mar 31, 2022 at 16:29
0 is - obviously - 1st of Jan, 1970 - the begining of time! :) — Maciejg
– Maciejg, Commented Mar 31, 2022 at 18:40

Novneet · Accepted Answer · 2022-04-19 17:48:16Z

0

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

answered Apr 19, 2022 at 17:48

Novneet

1

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

oracle insert o into timestamp column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related