# Dates in Parquet files

**URL:** https://community.dremio.com/t/dates-in-parquet-files/3301
**Category:** Dremio University
**Created:** [May 2, 2019, 4:15pm UTC](https://community.dremio.com/t/dates-in-parquet-files/3301 "2019-05-02T16:15:56Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![annv11](https://avatars.discourse-cdn.com/v4/letter/a/e56c9b/32.png) [@annv11](https://community.dremio.com/u/annv11)
#### Post date: [May 2, 2019, 4:15pm UTC](https://community.dremio.com/t/dates-in-parquet-files/3301/1 "2019-05-02T16:15:56Z")

</div>

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