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