Re: [sqlite] Group by week

Moshe Sharon writes: > > Hi > > How can I select group by week > > moshe The steps below are an idea - let me know if it works OK. There is an arithmetic expression known as 'Zeller's congruence' for giving the day of the week, 0-6 ... look it up. The last step in the

Re: [sqlite] Group by week

: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Tom Longbotham Sent: Thursday, February 05, 2009 1:05 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Group by week Hi Moshe, There are probably a number of ways to do this. One possibility

Re: [sqlite] Group by week

, John Stanton <jo...@viacognis.com> wrote: > You need a function which gives the week number. Note that this is > calculated differently in the USA and Europe., so you need to use the > correct rules to write the function. > > Moshe Sharon wrote: > > Hi > > >

Re: [sqlite] Group by week

You need a function which gives the week number. Note that this is calculated differently in the USA and Europe., so you need to use the correct rules to write the function. Moshe Sharon wrote: > Hi > > How can I select group by week

Re: [sqlite] Group by week

Hi, perhaps you want to look at http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions or perhaps you would want to post a little more information about your problem Martin Moshe Sharon wrote: > Hi > > How can I select group by week

[sqlite] Group by week

Hi How can I select group by week moshe ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users