Teradata SQL

Teradata SQL related posts in this category

CAST function in Teradata

CAST function converts one datatype to another datatype in teradata. The value must be compatible with new datatype else it will result in error. CAST… Read More »CAST function in Teradata

There is no sysdate built-in function in Teradata. You can use current_date and current_timestamp function.You can also create custom function named "sysdate" to replicate it… Read More »Sysdate in Teradata

Top 20 Teradata Date Examples

Teradata Date Functions Date consists of 3 parts – Day , Month & Year. When we combine all 3 parts together we get the output… Read More »Top 20 Teradata Date Examples

Teradata concatenate – syntax and example

In Teradata, we can use concatenation operator to link multiple string or numeric or expression values into single value. Input for concatenate can be two… Read More »Teradata concatenate – syntax and example

Teradata Numeric overflow occurred during computation

Numeric overflow in Teradata occurs while handling numeric values in computation or transformation. Numeric overflow occurs when you try to load or compute numeric value… Read More »Teradata Numeric overflow occurred during computation

50 Teradata Interview Questions & Answers

50 Teradata interview questions to gain some confidence before your first round of interview. I am sharing below 50 Teradata Interview questions which covers various… Read More »50 Teradata Interview Questions & Answers

Moving from Teradata to Hadoop – Read this before

It's been few years since I have been working on HIVE, Impala, Spark SQL, PySpark, Redshift and in the journey so far I have migrated… Read More »Moving from Teradata to Hadoop – Read this before

Convert number to TIME in Teradata

While calculating measures you may want to convert seconds to TIME. Say you want to know how many HOURS,MINUTES & Seconds constitute this number. Example… Read More »Convert number to TIME in Teradata

Teradata TPT Export script

If writing a typical TPT script is tedious task for you then you may try using existing TPT templates to quickly write a TPT script.… Read More »Teradata TPT Export script

Fetch Metadata of View in Teradata via HELP

Recently someone in my team asked me how to fetch column list along with datatype from VIEW definition via jdbc connection. I proposed couple of… Read More »Fetch Metadata of View in Teradata via HELP