Ask a very simple SQL how to deal with strings?

lvjianlan

The field tdate in the table is of type varchar (50)

The content looks like this
2017-01-23
2017-12-15

How to turn it into

As long as the year and month (the year is the same), add a 0 after the month
For example, the two records above should look like this:
2017001
2017012
Like this?

cv4bf5d65fd

select replace(left('2017-01-23',7),'-','0')

我是杀人狂

select tdate=left(tdate,4)+'0'+substring(tdate,6,2) from tablename

fanfan1980

select rtrim(year(tdate))+right('000'+rtrim(month(tdate)), 3) from tbName

kxiaper

select convert(varchar(4),getdate(),112)+'0'+substring(convert(varchar(6),getdate(),112),5,2)

wgfxman

select left(tdate,4)+'0'+substring(tdate,5,2) from..

wgfxman

select left(tdate,4)+'0'+substring(tdate,6,2) from..

cv4bf5d65fd

select replace(left(column_name,7),'-','0') from table_name

unkmass

select left(tdate,4)+'0'+substring(tdate,6,2)

hiqwolfzzh

select datepart(yy,tdate)+'0'+datepart(mm,tdate) col from tablename