On Mon, 17 Aug 2009 07:44:15 -0400, "Igor Tandetnik" <itandet...@mvps.org> wrote: >update membres set dateinscription= > substr(dateinscription, -4) || '-' || > (case substr(dateinscription, 4, length(dateinscription) - 8) > when 'January' then '01' when 'February' then '02' ... > when 'December' then '12' end) || '-' || > substr(dateinscription, 1, 2); > >Substitute correct month names. Converting dateconnexion is left as an >exercise for the reader.
Thanks, I'll give it a shot. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users