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
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