sql server . How they can be conveted to valid TeraData types

Database

sql server . How they can be conveted to valid TeraData types

Tell how below datatypes in sql server . How they can be conveted to valid TeraData types?

int

Tinyint

Smallint

bigint

Decimal(18,5)

numeric[p[,s]]

float

real

smallmoney

money

Varchar(10)

Char(4)

nvarchar(50)

Smalldatetime

Datetime

Date

5 REPLIES
Senior Apprentice

Re: sql server . How they can be conveted to valid TeraData types

Most datatypes are exactly the same in Teradata, please check the manuals:

http://www.info.teradata.com/htmlpubs/DB_TTU_14_10/index.html#page/SQL_Reference/B035_1143_112A/titl...

(small)money doesn't exist (use DECIMAL instead) 

DateTime -> TIMESTAMP

Varchar/nVarchar -> VARCHAR CHARACTER SET LATIN/UNICODE

Re: sql server . How they can be conveted to valid TeraData types

Thank you

Re: sql server . How they can be conveted to valid TeraData types

I need a type "Money" variable in Teradata 

Teradata Employee

Re: sql server . How they can be conveted to valid TeraData types

Well, you could create a User Defined Type (ref. the SQL Functions and SQL External Routine Programming manuals), but before you go to all that trouble, think about whether you really need it.  Can you live with simply converting it to Decimal(x,y) with a money-type Format phrase?  What are the actual requirements for this domain?  Do you need anything specific to the Money type, or is it just desired because SQL Server has it?

Senior Apprentice

Re: sql server . How they can be conveted to valid TeraData types

You probably don't need MONEY:

Bad habits to kick : choosing the wrong data type