Questions tagged [weekend]
117 questions
1
vote
1 answer
How to throw out WEEKENDS from calculation in SQL QUERY?
I have SQL query which returns average utilization for some worker for previous year.
SELECT Name, AVG (hsum)
FROM
(
SELECT Name,sum((number_hours)/8)*100 AS hsum
FROM
T1
WHERE name='PERSON_A' and bookeddate>='2012-01-01' and…
Stefke
- 141
- 8
- 19
1
vote
3 answers
function that change date if it is weekend
I ve done a function that change date if it is a weekend but Instead of giving me the next day it do to me day+1 for example I had an input with the 31-09-2012 wich was the last sunday.
I have my function