On Wed, Oct 27, 2010 at 8:09 AM, jose isaias cabrera <cabr...@wrc.xerox.com>wrote:
> > What I would like to do is a call that can fix the dates to the correct > format, ie. YYYY-MM-DD, so that the final data looks like this, > > How about UPDATE Table1 Set d1=Replace(Replace(d1, "-", "-0"), "-00", "-0") Max Vlasov maxerist.net _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users