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

Reply via email to