Name SQL Single Row functions (for each of the following) that 1. returns a number.

Question

Name SQL Single Row functions (for each of the following) that 

(i) returns a number. 

(ii) returns lowercase letters. 

(iii) returns names of days.

For example: “Monday”, “Tuesday”. 

(iv) returns weekday number.

For example : 

1 for Sunday, 2 for Monday, 3 for Tuesday.

Answer 1

(i) ASCII () function returns a number. 

(ii) LCASE () function returns lowercase letters .

(iii) DAYNAME () function returns names of days. 

(iv) DAYOFWEEK () function returns weekday number