Re: Changing Date Type

[Duncan Hill]

On Friday 05 November 2004 15:56, Amit_Wadhwa@stripped might have typed:
> Yes, but I want to be able to insert into the column dates in the format
> d-mmm-yy

MySQL has a date format function that you can use to translate the format.  
The format in the table is always yyyy-mm-dd.  Use translation functions on 
the way in and the way out of the database to transform the date into the 
format you want.

Data input form and display form do not have to equate to the storage form.