dvdates=2018-01-01 00:00:00
1.convert(varchar(10),dvdates,121) as dvdate
dvdate =2018-01
2.substring(dvdate,1,7) AS dvdated
dvdated=2018-01
dvdates=2018-01-01 00:00:00
1.convert(varchar(10),dvdates,121) as dvdate
dvdate =2018-01
2.substring(dvdate,1,7) AS dvdated
dvdated=2018-01
转载于:https://my.oschina.net/u/3328774/blog/1548659