Scribd
Upload
57 views8 pages

MySql Functions

The document outlines various string and date manipulation functions in a programming context, including examples of how to use functions like UCASE, TRIM, and LENGTH. It provides syntax and usage for extracting parts of strings and dates, as well as formatting them. The content appears to be a guide or reference for coding functions related to character and date operations.

Uploaded by

samgupta01007
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
57 views8 pages

MySql Functions

The document outlines various string and date manipulation functions in a programming context, including examples of how to use functions like UCASE, TRIM, and LENGTH. It provides syntax and usage for extracting parts of strings and dates, as well as formatting them. The content appears to be a guide or reference for coding functions related to character and date operations.

Uploaded by

samgupta01007
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
You are on page 1/ 8
\ Nee 1 CH= 6 IR ene - | AD. Tevt_/. testi Funchions och oem C of n I, Select CHAR ADS { eg le CE EDN Cote EN arate eee) Pom tude ut | if Ename is Pi Lemame 1s Rani in tate “tudeut? (a oem 2 tathest any space — soar eee cat. | Cemane“—*L-nace aan ate a \| Lower | LCase Looute snot Deters case(“ Riva” ) ; A ie as enn EEE UPPER [UCASE > gun thing to_Capitol L te 2 £4 ~ 0 Select Ucase (“infnemostian?” ) 5 Ana» INFORMATION hy Select TRIM # ere we’) 5 are es _ ji) Select TRIM Ctaaihing “ae: From “## TPH H?); TP | ss cancl. Shr g Ste | aan eat. ue ee ™ Mh mit Atud name * S| Select INSTR (Siud-name , ‘am? ) teven tude nt aa ————* hin xteitement Abmios all tHe home 7 a Lahloneni ete ohne ee lentaca,> ome . 4) LENGTH 5 shou} Gute ctAne tn utes | v] cust oh oy 2a Select ) EnaTH /* Penal e’) - + Ana! 6 A EeraaeS elias the deYnast ounhen of Chana eg Select FET (Ra zar? aig ing: “RA RIGHT 9 snetinn Te—tcightiast asmben cf clanacks | . _— Select Rreut o/s S Acre RAMA 5) by a on Mumbesrs select mon 4) 9 zt _ OR [ ae lect I MoD ¥ PRs Seti x OR lect JI fe 4; —WnlPouer J Pou) 2 waieed Zp Hhe oes “4: — Select PoweRlu a) eee oat | aaa | YX = yxy =/— | i Saeeeeea I a hy _ | sted a a Select St Gn fo) 5 Axe ee alec NSC (0) Oe ee ti mat aU.3 So puna ab 1 es Seledt TRuucate 25-69 -1), C) Dare ame FuncTr ons CURD wet cunsent cade in YYYY-mm-9p feud ie d093-ol1-ad Select curpate ©) +10 + ____Ang:__d0a3 - 08 - 01 = cs Select CTE ee | : —b)_DaTeL 2 => extsoct the. ae From _datelime cypnestios ge = : oes Pee: “@okd-ai-28 D4: 28 5 ea Qh Bleich WT i Sa al oat month pron wos : ie a Les oy a2’) 3 a aie | Ang sot a | 4 Henman aehon ane i 8s Se =o)= 22’ ) | | Ls | na Amon 5 io Ge To Se “#083 -0l-ad’), b)Davoemenny 6) => selum day of _ month | Co as oe | | i S f f DA Ey ae) 2 . aa ’ Slee Davormonrn (S088 al = at); | Aye ag bh | | i 1) Davorweenc) =. doy of week —Caange 21 | t ean ; Bi Select Dayar WweEX C'fod3 —ol= 28°} 3 — eee ise eel — 40_DAv oF YEAR( ) = shun day of the yea» Caonge 1 > 366) a a es a : Angad Su Functions ‘oncat¢ ) + Po wER/ > : _ ESAS) + RounwDé > = __|l-+ SUBSTRCY. + STGN/ ) MEC Ye = + UCASE CD PSR yaiae) 2 SISTER TES + TRUNCATE C) + YVEARC) —_ Ho TERT) + DAYNAME C) i+ TRIMCY * DAYOE MONTHC) ——_ | INSTR) *DAVOE WEEKLY — LENGTHO + DAYoEVEARC) SEE «Nows “RIGHTLD -SvSDATE() SMT) Pe eee

You might also like