Re: [sqlite] Changing Date Format

2010-10-27 Thread jose isaias cabrera
"Max Vlasov" wrote... > On Wed, Oct 27, 2010 at 8:09 AM, jose isaias cabrera > wrote: > >> >> What I would like to do is a call that can fix the dates to the correct >> format, ie. -MM-DD, so that the final data looks like this, >> >> > How about > > UPDATE Table1 Set

Re: [sqlite] Changing Date Format

2010-10-27 Thread jose isaias cabrera
"BareFeetWare" wrote... > On 27/10/2010, at 3:09 PM, jose isaias cabrera wrote: > >> I know I can do a bunch of sets, such as this one, >> >> UPDATE table1 set d1 = '2010-01-01' >> where >> d1 = '2010-1-1'; >> >> but that is a lot of coding. > > > Perhaps something like: > > create table

Re: [sqlite] Changing Date Format

2010-10-26 Thread Max Vlasov
On Wed, Oct 27, 2010 at 8:09 AM, jose isaias cabrera wrote: > > What I would like to do is a call that can fix the dates to the correct > format, ie. -MM-DD, so that the final data looks like this, > > How about UPDATE Table1 Set d1=Replace(Replace(d1, "-", "-0"),

Re: [sqlite] Changing Date Format

2010-10-26 Thread BareFeetWare
On 27/10/2010, at 3:09 PM, jose isaias cabrera wrote: > I know I can do a bunch of sets, such as this one, > > UPDATE table1 set d1 = '2010-01-01' > where > d1 = '2010-1-1'; > > but that is a lot of coding. Perhaps something like: create table table1 ( id integer primary key ,

[sqlite] Changing Date Format

2010-10-26 Thread jose isaias cabrera
Greetings and salutations. I have this data entry problem, that I have placed a fix for the users, but I have entries in the DB that have the wrong date format. There are dates entered in this format, 2010-1-1 instead of 2010-01-01. Say that I had this table, table1. id,st,ca,d1,d2