PooLpi <poo...@...> 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. Perhaps an SQLite feature request to add these format specifiers would be looked on favourably, after all, there is a precedent with %f and %J. If using the C API, you could also create your own function to do the job using http://www.sqlite.org/c3ref/create_function.html Regards, MikeW _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users