Which of the following displays the order date for order 1000 as 03/31? a. SELECT TO_CHAR (orderdate,

Question:

Which of the following displays the order date for order 1000 as 03/31?

a. SELECT TO_CHAR (orderdate, 'MM/DD')

FROM orders

WHERE order# = 1000;

b. SELECT TO_CHAR (orderdate, 'Mth/DD')

FROM orders

WHERE order# =1000;

c. SELECT TO_CHAR (orderdate, 'MONTH/YY')

FROM orders

WHERE order# =1000;

d. Both a and b

e. None of the above

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 12c SQL

ISBN: 978-1305251038

3rd edition

Authors: Joan Casteel

Question Posted: