List:General Discussion« Previous MessageNext Message »
From:Duncan Hill Date:November 5 2004 4:17pm
Subject:Re: Changing Date Type
View as plain text  
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.
Thread
Changing Date TypeAmit_Wadhwa5 Nov
  • Re: Changing Date TypeMartijn Tonies5 Nov
RE: Changing Date TypeAmit_Wadhwa5 Nov
  • Re: Changing Date TypeMartijn Tonies5 Nov
  • Re: Changing Date TypeDuncan Hill5 Nov
RE: Changing Date TypeAmit_Wadhwa5 Nov