Snowflake csv upload turned the date format into "0022-10-02". Is there a best way to change the "0022" format to "2022" format as NEW_DATE shows?
| ORDER_DATE | NEW_DATE |
|---|---|
| 0022-10-02 | 2022-10-02 |
| 0022-10-02 | 2022-10-03 |
I've tried:
df["ORDER_DATE"] = pd.to_datetime(df["ORDER_DATE"], format='%YYYY%mm