Wrong datetime format when using Streamlit Cloud but correct when deploying app locally

[S_R]

Hi there,

I have created some code to upload data to snowflake.
When creating the code and running the app locally the data gets populated in the table with the correct format.
However, when moving the code to git hub and using the community cloud app the data get inserted in a wrong format.

Code used:

                file_df['DATE_'] = pd.to_datetime(file_df['DATE_'], format='%Y-%m-%d %H:%M:%S', utc=True)

Do I need a different format when using the community cloud on github?

The first one is correct the second incorrect.

Thanks

[dataprofessor]

Hi @S_R

Could you share a minimal reproducible example showing this, it’s rather difficult to reproduce without a starting data or code to work with.

Also, if data is initially displayed incorrectly, can you use Pandas built-in functions to format them back into the correct form.