Hello,   I am running a BTQ script which is generating a .CSV file. One of the column in the file is a number but datatype for the same in the parent table is defined as CHAR. I am using a cast function to convert it into bigint( number is 13 digits long), results are fine when I am running this query in SQL Assiatant.

My customer has loaded a TD test table with a date & time column that looks like this: Column:      XXXXXX   varchar(23)  Data: 7/31/2014 9\:20\:03 AM 8/4/2014 8\:23\:15 AM 12/6/2014 2\:31\:07 PM    What is the quickest/easiest way to convert the data to TIMESTAMP(6),  if possible at all ?   

Hi, I am a newbie in teradata and so am not familiar with casting/ formatting concepts... can you please clarify the below queries... 1. I have an export using below syntax

Hello I keep getting the above error message after the query below has been running for a minute or so. 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  

Hi everyone, I'm tryng to build a set of queries with the objective of getting the DDL of tables only from the info inside the dbc tables (columns, tvm, dbase, tableconstraints...). I started from the table dbc.columns to get all the info about every field of a table. Below you can find the work in progress query.

Hi All, I want to select the current_timestamp in a specific format 'YYYYMMDDHH24MISS'. Can you please let me know how I should go about it?

Hi Folks,  Can anyone explain the significance of MODE and FORMAT in Utilities like Fast Export and Multi load ? And what are the various MODE and FORMAT are avilable at this end ? I have seen some scenario's where RECORD has been used as MODE.

I want to remove periods from the concatenated string. Please help as I tried all options inlcuding Cast, Format etc.   My query is SEL CONCAT(id, rec_num, line_no, dep_no, asp_num, pr_num) as mystr from table_oemsp   I get the output as mystr 0.0.300.900.0 11.20.123.123.20 etc.  

Hi all,

Hi, I am trying to export data from a table in which one column  has a data type of Decimal(38,0).   Query: select sa from aa;Result: When I run the select statement in SQL assistant....the output is fine....like below   sa