Re: [sqlite] week number - feature request - extend strftime for ISO week?

2009-01-12 Thread MikeW
PooLpi writes: > > Thanks MikeW, > > Is there a way to do strftime %W with another function. > It don't seems to be possible with datetime. > > Thanks > > PooLpi The Linux 'date' command does support %G/%g/%V referring to ISO week num, which suggests an extension feature for ISO support. Pe

Re: [sqlite] week number

2009-01-08 Thread PooLpi
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 > PooLpi writes: > > > > > Hello, > > > > Happy new year 2009 to the list ;) > > > > I'm working on weeks with Perl (DateTime module) and Sqlite. >

Re: [sqlite] week number

2009-01-08 Thread MikeW
PooLpi 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 : -M

[sqlite] week number

2009-01-08 Thread PooLpi
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 20