Marek: Created page with "Group by day of the week (using date functions)

schema:gisq

We might want to count, or find the average by days of the week. Thi..."

2012-07-17T15:14:57Z

Created page with "Group by day of the week (using date functions) <div class='ht'> <div class=params>schema:gisq</div> <div> We might want to count, or find the average by days of the week. Thi..."

New page

Group by day of the week (using date functions)
<div class='ht'>
<div class=params>schema:gisq</div>
<div>
We might want to count, or find the average by days of the week.
This approach uses the date functions.

'''In this example we note that top of the pops usually
goes out on a Thursday or Friday.'''
</div>

<source lang=sql class='tidy'></source>
<source lang=sql class='setup'></source>

<source lang='sql' class='def e-oracle'>
SELECT TO_CHAR(wk,'D'), COUNT(song)
FROM gisq.totp
GROUP BY TO_CHAR(wk,'D')
</source>

<source lang='sql' class='def'>
SELECT DAYOFWEEK(wk), COUNT(song)
FROM totp
GROUP BY DAYOFWEEK(wk)
</source>

<div class="ecomm e-db2" style="display: none">
DAYOFWEEK gives 1 for Sunday, 2 for Monday,... 7 for Saturday.

An alternative is to use WEEKDAY which gives 0 for Monday, ... 6 for Sunday.
</div>
</div>
{{DATE and TIME ref}}

Date functions - Revision history

Marek: Created page with "Group by day of the week (using date functions) schema:gisq We might want to count, or find the average by days of the week. Thi..."

Marek: Created page with "Group by day of the week (using date functions)

schema:gisq

We might want to count, or find the average by days of the week. Thi..."