Re: [sqlite] SELECT question (computing day of week the using strftime() function)

2010-05-02 Thread Bernie Reiter
) -- Message: 13 Date: Sat, 1 May 2010 21:54:37 + (GMT) From: Bernie Reiter <bernie_on_the_road_ag...@yahoo.co.uk> Subject: [sqlite] SELECT question (computing day of week the using strftime() function) To: sqlite-users@sqlite.org Message-ID: <606363.46898...

Re: [sqlite] SELECT question (computing day of week the using strftime() function)

2010-05-01 Thread Jean-Christophe Deschamps
>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. > >$ sqlite3 test.db3 >SQLite version 3.6.20 >sqlite> create table test (date VARCHAR(20), money

[sqlite] SELECT question (computing day of week the using strftime() function)

2010-05-01 Thread Bernie Reiter
Dear List Members, I do need your wisdom and experience. Thank you very much for sharing these with me ! I have a table into which I import data records from an external source. These imported data records are all containing a date field. I can change the field definitions in this table