MySQL

(Chapter 10 - Functions in HTML)

1.    Write the purpose of the following functions :

a)     Curdate()

b)     Sysdate()

c)      Dayofweek(date)

d)     DayofMonth(date)

e)     Dayofyear(date)

f)       Power(4,2)

2.    Write the output of the following functions :

a)     Concat(“Super”,”Hero”)

b)     Substr(“teenager”,5,3)

c)      Rtrim(“   hello friends      “);

d)     Left(“Informatics Practices”,6)

e)     Lcase(“GovinDa”)