thanks, that's what I feared already.. although ugly, will do it that way so far as I don't want to do any other pre-processing on the fixed CSV's I receive. moreover I just found out STR_TO_DATE isn't available in mysql 4.0 anyway..
Michael > -----Original Message----- > From: Jigal van Hemert [mailto:[EMAIL PROTECTED] > I'm afraid that the syntax states that you can only use a > list of column > names. > > I think the best you can do is make an extra varchar column > to hold the raw > 'date' value from the csv and use an extra query to convert > it into a format > suitable for the gmtDate column. > > Regards, Jigal. > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]