Handling return type for old date functions

Learn about the changes related to the return type for some of the originally introduced date functions. The return type is changed from string to date.

Before upgrade to CDP

Some of the original date functions, such as TO_DATE, DATE_ADD, and DATE_SUB returned string values instead of date values. This was because the date return type was not available in Hive when these functions were introduced.

After upgrade to CDP

HIVE-13248 changes the return type of to_date, date_add, and date_sub functions from string to date.