Teradata SQL related posts in this category
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 »
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 can also apply different formats on output datatype. This is really helpful for date & timestamp columns. Teradata CAST Syntax Casting in Teradata is done using "CAST" function with the …
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 …
Teradata Date Functions Date consists of 3 parts – Day , Month & Year. When we combine all 3 parts together we get the output of DATE datatype. In Teradata, any function which you can apply on DATE datatype can be considered as DATE Function. In my opinion, Teradata Date Functions can be classified into …
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 or more but output of concat is always one. In Teradata, concatenate operator is represented by "||" i.e two vertical lines. You can also use '!!' i.e. two exclamation mark …
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 »
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 …
