# Dash DataTable DateTime

**URL:** <https://community.plotly.com/t/dash-datatable-datetime/27283>\
**Category:** Dash Python\
**Created:** [August 14, 2019, 9:08pm UTC](https://community.plotly.com/t/dash-datatable-datetime/27283 "2019-08-14T21:08:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![QEDELouw](https://avatars.discourse-cdn.com/v4/letter/q/8e7dd6/32.png) [@QEDELouw](https://community.plotly.com/u/QEDELouw)\
**Post date:** [August 14, 2019, 9:08pm UTC](https://community.plotly.com/t/dash-datatable-datetime/27283/1 "2019-08-14T21:08:12Z")

</div>

I am using Dash DataTable and have datetime64 types in columns that have been read from a JSON object that was stored in a Store component.  
The column’s that are datetime64 are displayed as followed:

1975-11-08T00:00:00

Is there a way to display the date with no time data without changing the dtype to object?

I have tried this:

```
mainData = pd.read_json(data, orient='table')

for cols in mainData.columns:
        print(mainData[cols].dtype)
        if mainData[cols].dtype == 'datetime64[ns]':
            mainData[cols] = pd.to_datetime(mainData[cols]).dt.normalize()
            # This changes the type to object which is not ideal.
            # mainData[cols] = pd.to_datetime(mainData[cols])
            # mainData[cols] = mainData[cols].dt.date
        print(mainData[cols].dtype)
    print(mainData.dtypes)

```

![image](https://us1.discourse-cdn.com/flex024/uploads/plot/original/2X/2/2f2971cdc3b7d738a30c4865c06a37a00403e879.png)

If I print out the column no time data is printed out only when displayed in DashTable:  
datetime64[ns]  
0 1975-11-08  
1 1974-08-30  
2 1978-10-15  
3 1980-04-05  
4 1975-03-12

---

<div class="post-metadata">

**Author:** ![flyingcujo](https://avatars.discourse-cdn.com/v4/letter/f/e480ec/32.png) [@flyingcujo](https://community.plotly.com/u/flyingcujo)\
**Post date:** [August 15, 2019, 7:19pm UTC](https://community.plotly.com/t/dash-datatable-datetime/27283/2 "2019-08-15T19:19:33Z")

</div>

Have you tried passing `format='%Y-%m-%d'` into the `pd.to_datetime` function?

---

<div class="post-metadata">

**Author:** ![QEDELouw](https://avatars.discourse-cdn.com/v4/letter/q/8e7dd6/32.png) [@QEDELouw](https://community.plotly.com/u/QEDELouw)\
**Post date:** [August 16, 2019, 7:51am UTC](https://community.plotly.com/t/dash-datatable-datetime/27283/3 "2019-08-16T07:51:49Z")

</div>

Unfortunately not

```
mainData[cols] = pd.to_datetime(mainData[cols], format='%Y-%m-%d')

```

Still outputs the same as it did before.  
I am thinking of just making a deep copy of the dataframe and using a dataframe just to display the results.