Home Forums SQL Server 7,2000 T-SQL Dates to quarters RE: Dates to quarters

  • August 29, 2005 at 10:22 am

    #585905

    SELECT TYPE,vendor,discontinueddate, datepart(quarter,[discontinueddate]) AS 'Quarter'

    from EOL

    WHERE (DISCONTINUEDDATE >= '01/01/2005')

    Order by Discontinueddate

    Works!!!