substring(convert(varchar,[FDATE],121),0,10) 20110131
substring(convert(varchar,[FDATE],10),0,10) 01-31-11
substring(convert(varchar,[FDATE],12),0,10) 110131
生成第一天和最后一天
select dateadd(dd,1,'2011-2-01')-day('2011-2-01') as a 2011-02-01
select dateadd(mm,1,'2011-2-01')-day('2011-2-01') as a 2011-02-28
select MIN(FCDATE) as startdate,MAX(FCDATE) as enddate from ... where ...