Tags for integer
Oracle Decimal to Teradata integer in TPT script
I am writing a PT script which loads from an oracle source to Teradata. PROBLEM_COL in Oracle is defined as DECIMAL(10,0). In Teradata PROBLEM_COL is defined as Integer. The load fails, and all rows are inserted into the error table. Reviewing the logs I believe I see the problem:
Teradata TPT oracle numeric integer decimal
varchar join integer
Consider two tables ,one has COLUMN_A defined as a VARCHAR(100) and the other has COLUMN_A defined as an INTEGER. When joining these two tables via COLUMN_A what does the optimizer have to do in order to accomplish the join?Convert VARCHAR to INTEGER  or convert INTEGER to VARCHAR? thanks.
join varchar integer convert
RANGE in INTEGER data fields
hi, i've got this table with the field ampcputime, which is a integer and used the following text in a query
Range integer case interval
Whom can help me explain the ‘46.06:18:08’ time.
Dear SQLers, A small question about time presentation using a integer data type. I juesed INTEGER FORMAT '99:99:99' to show time. below in steps my chalance :-)
integer time
Please explain the different behavious of substr
Please explain how this wotks. SEL SUBSTR(CAST(12345 AS VARCHAR(5)),1,3) This gives "123" as OP whereas SEL SUBSTR(12345,1,3) gives only "12", why does when passing integer/number it always reduces one explictly and gives output?
substr integer
Error while casting to decimal!
Hi All, I am trying to cast a column into decimal but its failing with the error
error casting decimal integer
Convert integer to TIME
Hi,   I need to insert data from a field A which is an integer to field B which is TIME(6). The data in field A is something like this:   1. 1256, which means 12:56:00 2. 0145, which means 01:45:00   I want to store it in field B as 12:56:00 and 01:45:00 Can you please help?
time sql integer
Converting a date to the Terdata date format
What is the best way to convert 'yyyy-mm-dd' to the Teradata interger storage of a date? (yyyy-1900)mmdd   For example: If my date was April 1, 2012 and it was stored in the database column in the format 'yyyy-mm-dd'. This is what I am trying to get: 1120401
teradata date format integer
Difference between 'Number' and 'Integer'
Can anyone please let me know what is the differenc between 'Number' and 'Integer' in Teradata?   Thanks, Kumar  
integer number
Conversion from type "DBNull" to type 'Integer' is not valid.
Would anybody know why I would be getting this error with Teradata 13.10.0.08, and not with Teradata 12? Conversion from type "DBNull" to type 'Integer' is not valid.  
teradata 13 integer dbnull conversion not valid

Pages