On Wednesday 11 April 2007 09:42:36 am James Hatridge wrote: > Hi all, > > I have records with the date in DD-MM-YYYY, but mysql wants them in > YYYY-MM-DD. Is there anyway of changing Mysql's format? >
Um, my suggestion would be to do some kind of CAST or CONVERT. I'm not so familiar with MySQL in terms of raw Transact-SQL, but in most cases you can do this. Given a text file (that is your source, right?) you can add as part of your INSERT statement something like a part of the string so you can piece it together. I don't know if you're using a program (C, PHP) or just SQL. In SQL, you would need to perform a lot of manipulation. You'd be better using Kate (or Vi) to parse the file yourself. -- kai Free Compean and Ramos http://www.grassfire.org/142/petition.asp http://www.perfectreign.com/?q=node/46 -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
