Luuk <Luuk@invalid.lan> posted in comp.databases.mysql:

> Rik Wasmus schreef:
>> On Thu, 01 May 2008 08:47:42 +0200, Rik Wasmus
>> <luiheidsgoeroe@hotmail.com> wrote:
>>> ÚPDATE data SET datefld = DATE(SUBSTRING(dateid,0,9);
>>
>> Ofcourse:
>> ÚPDATE data SET datefld = DATE(SUBSTRING(dateid,0,8));
>
> Of course:
> ÚPDATE data SET datefld = DATE(SUBSTRING(dateid,1,8));

Of course:
UPDATE data SET datefld = DATE(SUBSTRING(dateid,1,8));



--
Mark A. Boyd
Keep-On-Learnin'