ADS build 7.9.82

Teradata

Database - Financial

open table accts in Table Data Editor

Click on 2 nd row acct_end_date which is NULL and hit CTRL+SHIFT+T to enter the current date

Enter a primary key and then save. An error is generated in the log. There is an error in the update statement generated by ads.

UPDATE financial.accts SET acct_end_date='2009-08-15' WHERE cust_id=1362503
GO

If i open a query window and replace the above sql with below it works

UPDATE financial.accts SET acct_end_date= DATE '2009-08-15' WHERE cust_id=1362503
GO

Unexpected Error: Query(1/1) [Teradata Database] [TeraJDBC 13.00.00.06] [Error 3535] [SQLState 22003] A character string failed conversion to a numeric value.

com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 13.00.00.06] [Error 3535] [SQLState 22003] A character string failed conversion to a numeric value.
    at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:277)
    at com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:102)
    at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:285)
    at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:176)
    at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:108)
    at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:99)
    at com.teradata.jdbc.jdbc_4.Statement.executeStatement(Statement.java:331)
    at com.teradata.jdbc.jdbc_4.Statement.executeUpdate(Statement.java:506)
    at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalStatement.executeUpdate(TeraLocalStatement.java:155)
    at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalStatement.executeUpdate(TeraLocalStatement.java:126)
    at nmfl.wkNe.run(Unknown Source)