This is a discussion on 2 questions within the MySQL forums, part of the Database Server Software category; --> Rik Wasmus <luiheidsgoeroe@hotmail.com> posted in comp.databases.mysql: > Mark A. Boyd wrote: >> Luuk <Luuk@invalid.lan> posted in comp.databases.mysql: >> >>> ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Rik Wasmus <luiheidsgoeroe@hotmail.com> posted in comp.databases.mysql: > Mark A. Boyd wrote: >> 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)); > > Hehe, took me a while to see the difference, damned US international > keyboard.... > > Of course, it doesn't help that for the past 2 days here in Holland > we've had one national holiday after the next... <<<'hic'>>> :-) I had to come out of lurkdom for that one. I still have lots lurkin' and learnin' to do before I can be of much help around here. -- Mark A. Boyd Keep-On-Learnin' |
| Thread Tools | |
| Display Modes | |
|
|