HP-DB] mySQL table update
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:
I
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, Email
What can I say? Thank you very much for working on this problem! Helped
me a lot!
Niklas
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: 29. lokakuuta 2001 12:27
To: Niklas Lampén; Php-DB; Php-General
Subject: Re: [PHP-DB] mySQL table update
> I have a large ta
> 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
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 copy from
