import pandas as pd date='2020/11/26 12:00:00' date_time=pd.to_datetime(date, format='%Y/%m/%d %H:%M:%S')
dfc['Time_of_Sail'] = pd.to_datetime(dfc['Time_of_Sail'],format= '%H:%M:%S' ).dt.time
all_data['Order Day new'] = all_data['Order Day new'].dt.strftime('%Y-%m-%d')