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: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org