timestamp related problem

Tools & Utilities

timestamp related problem

hi frnds,
iam working on migration from oracle to teradata. my problem is

i hav time stamp in oracle '''2007-03-16T06:00:00-07:00'' (what is the equivalent timestamp for this in tdata).

i hav datatype like this -989999928799 (what is the data type for this  i mean negative values in teradata)

plz any one help me , this is urgent
Teradata Employee

Re: timestamp related problem


Look for "Timestamp With Time Zone" in "SQL Reference: Data Types and Literals" manual.