"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
"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
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"),
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
,
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
5 matches
Mail list logo