)
--
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...
>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
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
3 matches
Mail list logo