"Max Vlasov" wrote... > 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")
now that is short. Thanks. josé _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
