​Contents of ORDERS Table

​Contents of ORDERS table
Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP.
-​Based upon the contents of the ORDERS table,which of the following SQL statements will display the ship date for order 1006 as April 2,2002?

A) ​SELECT order#,TO_CHAR(shipdate,'Month DD,YYYY')
FROM orders;
B) ​SELECT order#,TO_DATE(shipdate,'Month DD,YYYY')
FROM orders;
C) SELECT order#,TO_CHAR(shipdate,'Month DY,YYYY')
FROM orders;
D) SELECT order#,TO_DATE(shipdate,'Month DY,YYYY')
FROM orders;