Hello, Happy new year 2009 to the list ;)
I'm working on weeks with Perl (DateTime module) and Sqlite. With the end of 2008 and the beginning of 2009 : In my database, if i select dates at the end of 2008, it gives me : week #51 => 22-28 dec week #52 => 29-31 dec ???? at the beginning of 2009 : week #0 => 1-4 jan week #1 => 5-11 jan With the Perl and the DateTime, when i iterate from the end of 2008 to the beginning of 2009: week #52 22-28 dec week #1 29 dec - 4 jan week #2 5-11 jan Here it' OK (at least for me ;) 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 -- '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