Teradata SQL

Teradata SQL related posts in this category

teradata

25 most important Teradata Date Functions (2022)

25 Teradata Date Functions examples Teradata Date Function Output Description SELECT DATE 2020-10-09 Fetch Current Date SELECT CAST(DATE AS VARCHAR(20)) 20/10/09 SQL Editor may modify the DATE column and display date value in some other format.To Display DATE in actual format use casting. SELECT CAST(DATE AS DATE FORMAT 'Y4-MM-DD') 2020-10-09 Display date in the user …

25 most important Teradata Date Functions (2022) Read More »

teradata

Sysdate 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 in Teradata. If you have worked in Oracle or MySQL then you must have used sysdate a lot. In this post we will see how you can use "sysdate" in …

Sysdate in Teradata Read More »

teradata

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 which is bigger than the permissible range for numeric datatype used in the query. The solution is cast the column used in computation to bigger numeric datatype. Maximum possible value …

Teradata Numeric overflow occurred during computation Read More »

teradata

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 topics and shall help in preliminary rounds of Interview. It covers basic architecture questions, utilities related – Fastload, Multiload, BTEQ questions, SQL questions, Stored Procedure related questions below. I have …

50 Teradata Interview Questions & Answers Read More »