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 ( )

(ii) LCASE ( )

(iii) DAYNAME ()

(iv) DAYOFWEEK ( )