Question
Question write SQL statements for the following.

(i) To print the current date and time.

(ii) To print the today ’s date only.

(iii) To print the month name from the date "2019-10-10 ".

(iv) To the month from the date "2020-01-10 "

(v) To print the square of 5.

(vi) To round of the number 345.56 upto 1 decimal place.

(vii) To print the modulus of 4 to 5.

(viii) To round of the number 4567.10 multiple of 10.

Answer

(i)

(ii)

(iii)

(iv)

(v)

(vi)

(vii)

(viii)

Need a full question paper?

Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.

Start Generating Free