At 1:49 PM -0400 09-08-2000, Thomas D. Palombo wrote:
>I've been trying to replace the year within a field from those that have
>been added in error. How can I use the "replace" command to correct the year
>within a date format of MM-DD-YYYY.
>For example: The data of 07-04-2100 was entered in several places and I
>would like it to be 07-04-2000.
MM-DD-YYYY is not a legal date format in MySQL. Are you storing these
values as dates or as strings?
>Dr. Thomas D. Palombo
>Computer Science, PhD
>Planner / Strategist
>Resource Management Department
Paul DuBois, paul@stripped