Please cancel my subscription to this list!! My Mail client is overwhelmed.
Roger Andersson wrote:
>> I need to find out how many specific weekdays (e.g., how many
>> Sundays) I have in any given range of dates.
>> My problem: How to use the COUNT function in combination with
>> the strftime() function.
>>
>>
> Maybe something like
>
> sqlite3 test.db
> SQLite version 3.6.23
> sqlite> CREATE TABLE test (date TEXT, money INTEGER);
> sqlite> INSERT INTO test VALUES('2007-07-20', 1000);
> sqlite> INSERT INTO test VALUES('2007-07-21', 2100);
> sqlite> INSERT INTO test VALUES('2007-07-22', 2200);
> sqlite> INSERT INTO test VALUES('2007-07-27', 7000);
> sqlite> INSERT INTO test VALUES('2007-07-28', 2800);
> sqlite> INSERT INTO test VALUES('2007-07-29', 2900);
> sqlite> INSERT INTO test VALUES('2007-07-22', 9200);
> sqlite> SELECT strftime('%w', date) weekday, count(*) cnt FROM test GROUP BY
> weekday;
> weekday|cnt
> 0|3
> 5|2
> 6|2
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
