![]() |
Hello,
15 Jan 2015
,
|
![]() |
My customer has loaded a TD test table with a date & time column that looks like this:
12 Aug 2014
| 1 comment
,
|
![]() |
Hi,
25 Jun 2014
| 2 comments
,
|
![]() |
Hello I looked at this part... left join (select CCT_External_ID, CCT_Agent_ID from GDW_VIEWS. CCT_AGENT where CCT_External_ID between '0' and '999999') Rep_Trans_IDs on Rep_Emp_IDs.emp_id=Rep_Trans_IDs.CCT_External_ID
22 Apr 2014
| 4 comments
,
|
![]() |
Hi everyone,
08 Apr 2014
| 1 comment
,
|
![]() |
Hi All,
23 Jan 2014
| 7 comments
,
|
![]() |
Hi Folks,
03 Jan 2014
| 14 comments
,
|
![]() |
I want to remove periods from the concatenated string. Please help as I tried all options inlcuding Cast, Format etc.
29 Jul 2013
| 2 comments
,
|
![]() |
|
![]() |
Hi, sa
05 Oct 2012
| 7 comments
,
|
![]() |
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
,
|
![]() |
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
,
|
![]() |
I have to join two tables using a unique field but the trouble is one table has placed that unique field in all caps and the other table has the field in all lowercase. When joining these two they bring back nothing. When I look up the data individually I can find the same records in both tables.
10 Jan 2012
| 2 comments
,
|
![]() |
Hi all, I have to load some data using Teradata Parallel Transporter...
I have a record like: 1234ANA MARIA 20111209
I need to load something like: PID: 1234 DATE: 2011-11-09
I expected to do something like:
09 Dec 2011
| 2 comments
,
|
![]() |
What is the data format using by TPT\Fastload while primary transfer to Teradata instance? We using Fixed-width source-files for fasload - its a really excessive data (higly compressible). Does Fastload (or TPT) use a custom format for transmission to the lower coefficient of redundancy,
17 Nov 2011
,
|
![]() |
Hi, I want to use the FORMAT attribute to display the data in a specified format. Could anybody tell what do the the following format symbols means: 1) (I) 2) N 3) G
29 Aug 2011
| 2 comments
,
|
![]() |
Is it possible to get the timestamp to display the timezone like this using SQL? What I have so far: SQL: RESULTS: myTimeZone myTimeZone2
08 Apr 2011
| 1 comment
,
|
![]() |
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
,
|
![]() |
Hi Is there a way to convert TIMESTAMP data to ISO 8061 format, so the result will be something like: ' 2011-04-04T12:57:18.530'?
04 Apr 2011
| 1 comment
,
|
![]() |
My data: My current DDL: My current TPT Insert statement: The data is being stored in the database table with century of '19' instead of '20'. My data will always be century of '20': CREATE_DATE
28 Mar 2011
| 1 comment
,
|
![]() |
Can coalesce and format function go together? I want the output of a numeric field to be displayed in specific format ,and 0 when the value in the column is NULL. So, I use SELECT TRIM(COALESCE(Field,0) (FORMAT 'ZZZ,ZZZ,ZZ')) from Table; where Filed is the column name and Table is table name.
27 Oct 2010
| 1 comment
,
|
![]() |
Hi I created a table with a single column of TIMESTAMP(0) WITH TIME ZONE. When I try to insert value with the following statement INSERT INTO XOBTTEST (timestmp_with_zone) VALUES ('2010-10-20 14:23:00-05:00' (TIMESTAMP(0) WITH TIME ZONE,FORMAT 'YYYY-MM-DDbHH:MI:SSZ'); I got this error: When I try the following statement: INSERT INTO XOBTTEST (timestmp_with_zone) VALUES ('2010-10-20 14:23:00-05:00' (TIMESTAMP(0) ,FORMAT 'YYYY-MM-DDbHH:MI:SSZ');
23 Oct 2010
| 1 comment
,
|
![]() |
Hi, could anyone help me with formating a decimal ? I need to format a decimal(18,2) field with the following rule :
11 Oct 2010
| 3 comments
,
|