In the TO_CHAR (date) function, what do the format strings D, DD, and DDD produce? (choose one)
A) Character day of week, character day of month, and character day of year respectively
B) Day of week, day of month, and Julian date since 4713 B.C. 00:00:00 (midnight) respectively
C) Each produces numerical day of week
D) Numerical day of week, day of month, and day of year respectively

Question

Quizplus · Accepted Answer

The format strings D, DD, and DDD in the TO_CHAR(date) function produce the numerical day of the week, day of the month, and day of the year, respectively.

In the TO_CHAR (Date) Function, What Do the Format Strings