目前資料庫的欄位是yyyy/MM/dd的文字型態目前想要select出來今天或指定日期的後十日,但是我不要年份，只要資料庫裡符合今天日期的後十天(不含年份喲...)不知道要如何做，請各位大哥指導一下.....謝謝

declare @temp table(tDate char(10))

insert @temp
select '2005/10/11'

insert @temp
select '2006/08/13'

select Right(tDate,5) as mmdd from @temp where datediff(d,Cast(tDate as datetime),GetDate())<=10

declare @temp table(tDate char(10))

insert @temp
select '2005/10/11'

insert @temp
select '2006/08/13'

select Right(tDate,5) as mmdd from @temp where datediff(d,Cast(tDate as datetime),GetDate())<=10

這個語法select Right(tDate,5) as mmdd from @temp where datediff(d,Cast(tDate as datetime),GetDate())<=10

也就是找出從GetDate()今天起,差DateDiff()十天以內的資料,並把日期欄位只取後五碼

如果是找到

'2006/08/13'這一筆

答案是'08/13'