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

Reply via email to