First of all what are Built-in functions?
These are functions which do not need any sort of arguments but still returns information about the system; user, date, time, session etc. Built-in functions are sometimes referred to as special registers. Mostly used with the SELECT statement.
SELECT <Built-In Function>
• ACCOUNT: – If you are wondering about your Teradata Account information just use this function to see your current account string.
• CURRENT_DATE: – Returns the current system date and it is same as the function DATE.
• CURRENT_TIME: – This function returns the current system time and current session ‘Time Zone’ displacement. This function is similar to the TIME function but with extra feature of Time Zone displacement.
• CURRENT_TIMESTAMP: – Returns the current system timestamp (including year, month and day) and current session Time Zone displacement.
• DATABASE: – If you are wondering how to find your current database name, use this function which returns the name of the default database for the current user.
• DATE: – As mentioned earlier, it does return the current date.
• SESSION: – Returns a number for the session the current user is in. Two sessions does not have the same number. If you want to identify your session, this is the function to use.
• TIME: – As mentioned, this function provides the current time based on a 24-hour day; mean to say for 4:00 pm, you would see 16:00:00.
• USER: – If you have forgotten your username after you have logged in, this command would come to your rescue. This one gives the user name of the current user.
11 comments
Skip to comment form
These are reaply fantastic ixeas iin regarding blogging.
Yoou havfe touuched sime good factrors here. Anny wway kesp up wrinting.
My wweb blog; xnxx18.pro
Write more, thaqts alll I ave to say. Literally, iit seems aas though yyou relied on thee vidro
to make your point. Youu obviously know what youre talking about,
wwhy waste you intelligyence oon juhst posting viddeos tto your eblog whjen yoou could bee iving
us somethiong enlightejing to read?
Chck out my site; naughty mom and daughter lesbian
ofvd9wuaptia6de48j35
Kegelmaster 2000 vgina exercises incontinent episodesStoies abput unisex nakrd fashhion dressing roomsCotee dee pabnlo sexy photosMothets dayy breastt cancer donationGlry hkle handjobsLatx righht alignmentSexx videos fropm the
60sBibpe an gayOnetouuch uultra testing stripsMutuql hand job storyWesst
ga eroyic massageBlack dick japaneseMeet n fuchk websiote passwordFrree mfmm xxxx
sex storiesEscorts toronto europeanBlac bahamian pornSound insertion eroticaTpelo pornLesbian fictioon ahgela temperanceAmasteur rzdio calklsign directoryBiig bull cockRugbby north ddakota escortsPlease fucking hepp meVintage adaultBiig titt porno picVctoria serert model nudeHustleer aphodisiac videoAerage nakked
chnubby womenGirrls habe diock with hairlViirtual sex silviaFreee full downlpoadable ebony pusswy moviesFreee maturee porn ppic hunterNigfers fuchking matureFrree momster anmal cocksFreee hkmemade
ebomy seex videosKendfa wilkjnson sewxy dancingIdentify
vitage indian potteryBiig asiann moviesIs itt normal forr a vagima tto smellAsian women whoo
lie white men https://xnxx3.cc/ Moovie off woiman brrast feedingFreee gayy maale aass pictureOldd pussy orgssm videoKanye fucking niggerRohgh
harfd fucdk storiesVaginaal orgasemReaal maturte womenn pornPaaris hilon seex vidieo freeSeduyced bys pornSuper brigut led stripAmatujre gjrls fisting nzked videoAdultt lagency boysFreee
slow sexx videosSexuql harrassment iin the workplace cnada lawsChewapest man boob removalNuude
bab slideshowFreee tden lesbiazn fistingAbbesy brioks nal movieJesica
eal sexx sceneBreasst enlargement workSexy pictures off leon kadenaGirll masturbtion dilldo squirtGoleen showeer girls free torrentDrty girls in bikiniAdut character kikyo swimVann haldn bottoms upp tabFucck
herr heer inn sleepGay bigg cookAdda ong esident eevil nudeTeen age mmutant ninbja turttle
vidiosFreee indfian mom sson xxxx storiesFree sexx
acct clipsMenn suckin cumTiiny teen bigg toyGuys cum onn french pussyWhatt do muslim thihk oof homosexualsLiving ith a hugge penisDeath xxxSeexy photo boothTop 77 nud blak menCatoon ssex wildRocck
bottopm iin montgomerdy alabamaPaired blowjkob photos50 year olld
boobJesssica simpswon insidde pussyAt shw updkirt galleriesNudee avv modelsTeen agbainst
gan violenceAdullt theatree directoryLoving annabellle sex scene clipAsian grocdery maylandFrree sex cartoon videoFucck maure teenNo
passworrd pornDestiuney nzked cartwheelGirll fucxking iin spaGils that like thdir asss lickedMyspac
eroyic b w bbondage iconsNudee sunbathing cabo picsMapp oof asian tsunamiSoon fucking
maidFemdom cagesSeex right after ovulation predictNakled collge lesbian picturesMadison arker handjobDevelopmental aspeccts off dult learning processs contextCuum sourNaked women exoticc outdoorSeexy
exhibitionbits devilFucking a preegnate womasn picturesGaabrielle solis nakedAduilt age-onset
asthmaEmmauelole vahgier nudeAduult swijm suirgery game
hzxmt4
Many thanks a great deal a lot with the top quality in addition to results-oriented help. My partner and i won’t think twice in order to promote your website write-up to help anybody who wants in addition to needs support concerning this area.
jjn1p4
Yo, 123win64’s the real deal! Been playing here for ages and the wins keep coming. Fair play and good vibes only. Check it out: 123win64
Heard about 89pkr from a friend and it’s actually really fun! Simple to get into, but hard to master. Worth a download. 89pkr
If youre looking for a new game to try, maybe hit up CCZZGame? Not my favorite, but maybe you’ll find somethin you like. Check it out: cczzgame
To add to the post,
ROLE and PROFILE built-in functions also exists and can also be used.
Useful indeed. The commands look obvious but only after knowing them that they exist.