Which function should the data architect use to fix this issue?

Refer to the exhibit.

A data architect needs to build a sales dashboard. Data is stored in a legacy database. The extracted data contains the date in the format, ‘YYYDDMM’. Due to the source date format, the dates are being loaded as numbers.

Which function should the data architect use to fix this issue?
A . Timestamp
B . Date
C . Date#
D . Timestamp#

View Answer

Answer: C