
判断日期时候为当年:
SELECT DateDiff(yy, '2018-01-02', GetDate())
返回结果0为当年。
获取当前季度:
SELECT DATEPART(QUARTER,GETDATE())
获取日期为第几季度:
SELECT CAST(datepart(q,'2018-01-02') as varchar(2))
判断日期时候为当前季度:
SELECT '' AS result WHERE
DateDiff(yy, '2018-01-02', GetDate())=0
AND cast(datepart(q,'2018-01-02') as varchar(2))=DATEPART(QUARTER,GETDATE())