Question

Write the SQL functions which will perform the following operations:

(i) To display the name of the month of the current date .

(ii) To remove spaces from the beginning and end of a string, “ Panorama “.

(iii) To display the name of the day eg, Friday or Sunday from your date of birth, dob. (name). 

(v) To compute the remainder of division between two numbers, n1 and n2

Answer 1

(i) monthname(date(now())) 

(ii) trim(“ Panaroma “) 

(iii) dayname(date(dob)) 

(iv) instr(name, fname) 

(v) mod(n1,n2)