Timestamp conversion failing

Database
Enthusiast

Timestamp conversion failing

Hello All. 

We have two tables as below. Both the tables have 1 column COLLECT_DATE_TIME Timestamp(1).

1. DB_DEV.ABCD

2. DB_TEST.ABCD

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

Ab

1 REPLY
Teradata Employee

Re: Timestamp conversion failing

If using ODBC, be sure DateTimeFormat option is IAA or AAA.