I am displaying a Pandas dataframe as a Dash datatable.
If I load the data directly on the datatable with the usual procedure the datatime columns (explicitly converted to datatime in Pandas) are displayed correctly.
If I use the Store in memory mode all is fine too.
However, if I switch to session or local modes, the timestamps are displayed as milliseconds.
While the app is loads they appear in the right format, but as soon as it has finished loading , they show as milliseconds.
Is this a bug or a feature? Is there anything that can be done to remediate this behaviour?
Converting the column to string actually seems to be a workaround (one needs to restart the app though):
df_table[‘date_opening’] = pd.to_datetime(df_table[‘date_opening’]).dt.strftime(‘%d %b %Y’)