Hello, Before I go ahead and write a script to loop through all the rows, I was wondering if SQLite supports functions to convert DD MM YYYY into the MySQL-friendly YYYY-MM-DD, and whether those functions are localized so that it understands month names in languages other than English?
Here's an example: SELECT dateinscription, dateconnexion FROM membres LIMIT 1; 26 Mai 2007|17 Août 2009 - 09h20 I'd like to update the row into "2007-05-26" and "2009-08-17 09:20", respectively. Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users