We have two tables as below. Both the tables have 1 column COLLECT_DATE_TIME Timestamp(1).
When I am inserting a value '2015-09-21 21:59:45' to DB_DEV.ABCD, its going thru successfully. Teradata is implicitly converting the value to Timestamp(1) and inserting. However, when my testing counterpart is inserting the same value to DB_TEST.ABCD, it is failing.
Is there any reason for such different behaviour at different dbs/users. Do we have any session parameter which is causing such difference. Would request inputs here.
Thanks in advance