* Roger Baklund
[...]
> UPDATE a SET new_date =
>
(
> MID(my_date,7,4),'-',
> MID(my_date,1,2),'-',
> MID(my_date,4,2));
huh? How did this happen...? I just checked my outbox, and the message I wrote
yesterday[1] contained "new_date = CONCAT(". It seems as the substring "CON" has been
replaced with a linefeed somewhere along the way...?
Anyway, trying again, the correct statement should be:
UPDATE a SET new_date = CONCAT(
MID(my_date,7,4),'-',
MID(my_date,1,2),'-',
MID(my_date,4,2));
[1] That was wednesday. With the current long delays on the list, this message will
probably not be read until friday... :/
--
Roger
sql
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
