Date Problem - Girish Agarwal - com.mysql.lists.mysql

2 messages in com.mysql.lists.mysqlDate Problem

From	Sent On	Attachments
Girish Agarwal	08 Aug 2003 09:12
Roger Baklund	08 Aug 2003 10:05

Subject:	Date Problem
From:	Girish Agarwal (giri...@yahoo.com)
Date:	08/08/2003 09:12:48 AM
List:	com.mysql.lists.mysql

Hi All,

I have added the date column ( column name is dolv ) in mysql as CHAR(10) as I needed the date in mmddyyyy separated by mm/dd/yyyy. Now I want to have this column contain the date whenever the updation to that column is done. Please advise as to how I can achieve this without losing the data I have already entered.

Thanks, Girish