![]() |
Hello everyone
11 Jan 2016
| 2 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
,
|
![]() |
Hello,
I'm very much new to Teradata and writting queries as such. I have a CHAR Type column which contains data as follows '2012-01-20 02:32:37.000000'.
How do I convert this CHAR type data to DATE Type, preferably as a timestamp?
Regards, ASR
09 May 2012
| 4 comments
,
|
![]() |
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
,
|