I have a parquet files, created by external tool.
Dates are saved as a # of days since 1/1/1970. Both Dremio and Drill sees it as a number. When I try to use Change Data type functionality, it seems that the number is interpreted as seconds since Unix epoch.
Is there anyway to convert this date without using a calculated column?
Thank you