sqlserver pandas 日期

select * from sqlserver,   convert(date, 23) => YYYY-MM-DD

pandas convert to date, drop time part,

df2['ym1'] = pd.to_datetime(df2['ym']).dt.date