prima della select:

codice:
<%
response.write weekdayname(day(date)) 
response.end
....
%>