Friday, May 27, 2011

list Built-in functions used in teradata ?


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 .

2 comments:

  1. Built in Function for Teradata13:--
    ABS
    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

    ReplyDelete
  2. Nice post ! Thanks for sharing valuable information with us. Keep sharing.. Big Data Hadoop Online Course Hyderabad

    ReplyDelete