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.
iv) To display the starting position of your first name(fname) from your whole name (name).
v) To compute the remainder of division between two numbers, n1 and n2.​

Answer 1

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.

iv) To display the starting position of your first name(fname) from your whole name (name).

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

plzzz mark as brainliest answer and follllowwww jsbdbdbbdbdbfbbdbbbddbabababsbfbdfbbfbbfbdbbdbbd

Answer 2

Answer:

The SQL functions for the given operations are as follows:

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

monthname(date(now()))

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

trim(“ Panorama “)

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

dayname(date(dob))

iv) To display the starting position of your first name(fname) from your whole name (name).

instr(name, fname)

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

mod(n1,n2)

#SPJ2