Question

Write the SQL functions which will perform the following operations:
i) To display the name of the day of the current date.
ii) To remove spaces from the beginning of a string, Python".
ii) To display the name of the month eg, January or February from your date
of birth.
iv) To display the starting position of word “Information” from
"Information Technology"
v) To compute the power of two numbers a and b​

Answer 1

Answer:

SQL Function

1) SELECT DAYNAME("2020-06-15");

2) SELECT TRIM('#! ' FROM ' #SQL Tutorial! ') AS TrimmedString;

3) SELECT MONTH('2020/05/25 09:08') AS Month;

4) SELECT

CHARINDEX('INFORMATION', 'INFORMATION TECHNOLOGY') position;

5) SELECT POWER(2,3)

FROM dual;

Hope it helps you!

all the best!