Sarthaks Test
0 votes
in Information Technology by (47.5k points)
closed by

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

1 Answer

+1 vote
by (46.3k points)
selected by
Best answer

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

(ii) trim(“ Panaroma “) 

(iii) dayname(date(dob)) 

(iv) instr(name, fname) 

(v) mod(n1,n2)

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.