What version of Orion are you using?
You can use LIKE similar to SQL. And the corresponding DATEPART functions, are Year(), Week, Month, etc..
In SWQL you can get the response time by querying Orion.ResponseTime entity or you can use the "navigation property" RepsonseTimeHistory on the Nodes Entity
Here is a SWQL query that groups the availability by Node, Year and Week
SELECT Nodes.NodeID, Nodes.NodeName, AVG(Nodes.ResponseTimeHistory.Availability) AS AvgAvailability, Year(Nodes.ResponseTimeHistory.DateTime)AS Year, Week(Nodes.ResponseTimeHistory.DateTime) AS Week
GROUP BY Nodes.NodeID, Nodes.NodeName, Year(Nodes.ResponseTimeHistory.DateTime), Week(Nodes.ResponseTimeHistory.DateTime)
Thanks for the clarification on LIKE and DATEPART. Regarding the version, i am using version 2. The Nodes.ResposeTimeHistory.Availability is taken over which period of time?, i didn't the design the query i posted, but if i can't use the availability from ResponseTime_Daily or ResponseTime_Hourly in SWQL, then the only option i have is Nodes.ResponseTimeHistory.Availability?
The Orion.ResponseTime exposes all the response time data for you. It includes daily, hourly and detail data which has not been summarized yet.