Hi am getting following error while inserting data into table.please help me on this.
This is my tables syntax
create table k.test (eventdate timestamp);
insert into k.test (eventdate) values(to_timestamp('07-FEB-14 07.37.38.000000000 PM','DD-MON-RR HH.MI.SS.FF AM'));
am getiing following error
name require 30 bytes in latin iternal form.
Am new to this blog where to post i dn't knw srry for anything wrong
Please any bdy help me on this
That's an error indicating a column or table name longer than the maximum of 30 characters.
Based on your DDL and Insert this error should not be returned, it must be caused by something else.
What's your TD release and which client do you use?
Plus 126.96.36.199 sounds like an ancient TD Express, you should install a newer version.
Are you shure there's a TO_TIMESTAMP function? This was introduded in TD14, soy you must have an self-developed UDF.
It's like any other switch in database technology:
Doing it on your own might be a big task, especially if you don't have expertise in the new DBMS.
There's 3rd party software like SwisSQL or Teradata's professional services to help migrating from your_favourite_DBMS_here to Teradata.
There are two issues with that timestamp (only Oracle calls a timestamp a date) string:
Or you (your DBA) install the Oracle UDFs including TO_DATE and TO_TIMESTAMP, availabe for download on DevEx, but you better ask your TD PS people for the latest version.
On TD14 those functions are built-in and you can use them as-is.