Thanks MikeW, Is there a way to do strftime %W with another function. It don't seems to be possible with datetime.
Thanks PooLpi 2009/1/8 MikeW <mw_p...@yahoo.co.uk> > PooLpi <poo...@...> writes: > > > > > Hello, > > > > Happy new year 2009 to the list ;) > > > > I'm working on weeks with Perl (DateTime module) and Sqlite. > > > ...snip... > > The ISO (ISO8601) definition says that the first week containing a > Thursday > > is week #1. > > > > My dates in the database are in this format : YYYY-MM-DD > > > > Why Sqlite gives me this #52 week number at the end of 2008? > > > > Thanks in advance, > > > > PooLpi > > > I think you will find that strftime %W quoted in the SQLite docs > (follow the link from http://www.sqlite.org/lang_datefunc.html) > does not use the ISO definition of week number, but rather the > more simplistic Unix one. > > Regards, > MikeW > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- 'Ebry haffa hoe hab im tik a bush'. Jamaican proverb _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users