I have a problem here which I can not find an answer.
My date fields (EmailD in this case) can be in four different formats:
a) dd.mm.
b) d.mm.
c) dd.m.
d) d.m.
So this is what I've tried to do to convert the dates to -mm-dd
format:
INSERT INTO feCompsT (ID, Company,
Ok, found the problem.. I've been fighting with this for like an hour
but the error was here:
POSITION() should be LOCATION().. Way to go Niklas! :)
Niklas
-Original Message-
From: Niklas Lampén [mailto:[EMAIL PROTECTED]]
Sent: 29. lokakuuta 2001 15:46
To: Php-DB
Subject: RE: [PHP-DB
I have a large table with quite many dates in format dd.mm. (don't
ask why :) and I want to convert them into -mm-dd for obvious
reasons. How can I do this the smartest way? I know I could do it with
php and update it row by row but that doesn't seem too smart. Can I
somehow do a