![]() |
I am writing a PT script which loads from an oracle source to Teradata.
28 Sep 2015
| 4 comments
,
|
![]() |
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.
08 Dec 2014
| 1 comment
,
|
![]() |
hi, i've got this table with the field ampcputime, which is a integer and used the following text in a query
27 Jan 2014
| 4 comments
,
|
![]() |
Dear SQLers,
04 Dec 2013
| 9 comments
,
|
![]() |
Please explain how this wotks.
02 May 2013
| 3 comments
,
|
![]() |
Hi All,
12 Apr 2013
| 9 comments
,
|
![]() |
Hi,
11 Dec 2012
| 12 comments
,
|
![]() |
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
25 Apr 2012
| 2 comments
,
|
![]() |
Can anyone please let me know what is the differenc between 'Number' and 'Integer' in Teradata?
Thanks, Kumar
05 Apr 2012
| 1 comment
,
|
![]() |
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.
02 Nov 2011
,
|
![]() |
This gets the date, how can I get the full timestamp? SELECT (CAST('1970/01/01' AS DATE FORMAT 'yyyy/mm/dd')) + CAST(my_time/86400 AS INTEGER) AS CONVERTED_TIME I have a table with a column that is an integer and has Unix epoch time data.
06 Apr 2011
| 2 comments
,
|