sql 指定日期查詢

串接字串以達到指定查詢日期的效果

SELECT    * FROM         vw_CourseList
WHERE     (CourseStart BETWEEN CONVERT(datetime, STR(YEAR(GETDATE())) + '/03/01') AND CONVERT(datetime, STR(YEAR(DATEADD(year, 1, GETDATE())))

                      + '/02/28'))