The main functionality of built in functions is that they dont need any arguments or paramaters and can be used directly with select to return system values.
Some of them are
• SESSION: – Returns a number for the session for current user .
• TIME: – this function provides the current time based on a 24-hour day
• USER: – This one gives the user name of the current user.
• ACCOUNT: – display's your Teradata Account information
• CURRENT_DATE: – Returns the current system date
• CURRENT_TIME: - This function returns the current system time and current session ‘Time Zone’ displacement.
• CURRENT_TIMESTAMP: - Returns the current system timestamp with TimeZone
• DATABASE: – It returns the name of the default database for the current user.
• DATE: – same as Current_DATE and is teradata built in .
Built in Function for Teradata13:--
ReplyDeleteABS
ADD_MONTHS ACOS
ACOSH
ASIN ASINH
ATAN
ATANH ATAN2
AVERAGE
BYTES CAST
CASE_N
CHAR_LENGTH CHAR2HEXINT
CHARACTERS
COS COSH
COUNT
CORR COVAR_POP
COVAR_SAMP
CSUM EXP
EXTRACT
FORMAT INDEX
HASHAMP
HASHBAKAMP HASHBUCKET
HASHROW
KURTOSIS LN
LOG
LOWER MAVG
MAXIMUM
MCHARACTERS MDIFF
MINDEX
MINIMUM MLINREG
MSUBSTR
MSUM NAMED
NULLIFZERO
OCTET_LENGTH PERCENT_RANK
POSITION
QUANTILE RANDOM
RANGE_N
RANK REGR_AVGX
REGR_AVGY
REGR_COUNT REGR_INTERCEPT
REGR_R2
REGR_SLOPE REGR_SXX
REGR_SXY
REGR_SYY ROW_NUMBER
SIN
SINH SKEW
SOUNDEX
SQRT STDDEV_POP
STDDEV_SAMP
SUBSTR SUM
TAN
TANH TITLE
TRANSLATE
TRANSLATE_CHK TRIM
TYPE
UPPER VARGRAPHIC
VAR_POP
VAR_SAMP
WIDTH_BUCKET
Nice post ! Thanks for sharing valuable information with us. Keep sharing.. Big Data Hadoop Online Course Hyderabad
ReplyDelete