Duh! EXTRACT() Sorry!
-----Original Message----- From: Crook, Richard W [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 6:04 PM To: '[EMAIL PROTECTED]' Subject: string date thing Hi all, It's my first posting here so sorry if this is a silly newbie question for the MySQL forum. I'd like to change a string that looks like "04/03/2002" to "2002-04-03". The initial column is, of course VARCHAR and I'd like it to be DATE. I've tried CHANGE and MODIFY, it changes only some of the dates and others are incorrect. I've also tried DATE_ADD() and adding +0 and +0.0. Thanks in advance! --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
