Re: Tricky date formatting issue

2004-03-31 Thread Jigal van Hemert
> 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

Tricky date formatting issue

2004-03-31 Thread Scott Haneda
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