GUID data type stores “16-byte binary values” that operate as globally unique identifiers.
 
It can be logically grouped into the following subgroups:
4byte-2byte-2byte-2byte-6byte
The standard textual representation is {12345678-1234-1234-1234-1234567890AB}.
 

Hi Guys
I am working on migration from Oracle to Teradata. I am facing few issues there. I would be glad if some one please clarify below questions.
 
1.

 
Hi 
I have created a table with column as TIME(0) data type.
When I look at the table DDL, through SHOW TABLE, it shows the column data type as 'Integet Format '99:99:99'.
Time data type are stored as integer internally. But, I need the column to be as TIME(0) in DDL insted of Integer.
 
Any thoughts ?
 

Hello.

I have a table (a bigint, b bigint)? where for any a is true that a>=b.
When queriing:

select sqrt(a-b) from table;

there is error, bad argument in sqrt() (don't remember exactly).

select * from table where a