> I have a column 'tmp_date' that was imported from a messy data set, trying
> to clean it up. The date is in the format of:
> m/d/yy and mm/dd/yy
>
> Somehow, I need to update a timestamp(14) column based on the tmp_date as
> the input.
Nice challenge ;-)
For MySQL 4.0.x:
SET @d='01/02/03';
SEL
I can not seem to wrap my head around the string functions I will need to
work this issue out... MySql 4
I have a column 'tmp_date' that was imported from a messy data set, trying
to clean it up. The date is in the format of:
m/d/yy and mm/dd/yy
Somehow, I need to update a timestamp(14) column b