ADS build 7.9.82
Teradata Server
Database fcy_test_db
T_ZONE
Select table T_ZONE
Right Click and Script Object to Window --> Insert
ADS gives the below SQL which is never executed. The format of Time is incorrect
INSERT INTO T_ZONE(T1, T2, T3, T4)
VALUES('1:39:43.0', '2009-8-15 1:39:43.0', '1:39:43.0', '2009-8-15 1:39:43.0')
GO
>[Error] Script lines: 1-4 --------------------------
[Teradata Database] [TeraJDBC 13.00.00.06] [Error 6758] [SQLState HY000] Invalid time.
The below format works
INSERT INTO T_ZONE(T1, T2, T3, T4)
VALUES('02:36:24.011', null, '03:36:24.011', null)
GO
INSERT INTO fcy_test_db.T_ZONE(T1, T2, T3, T4)
VALUES('13:48:08', '2009-08-15 13:48:13.421', '13:48:14', '2009-08-15 13:48:15.718')
GO
Modified AFTableColumn.getValueStub() to format data/time values as a two-digit string for Teradata.
Resolved as SVN revision 9921 of ADS trunk.
Issue #3003 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
Modified AFTableColumn.getValueStub() to format data/time values as a two-digit string for Teradata.
Resolved as SVN revision 9921 of ADS trunk.