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) length()/ instr()/ round()/ truncate() or any other correct Single Row Function that returns a number

(ii) lower() / lcase ()

(iii) dayname ()

(iv) dayofweek ()