List:General Discussion« Previous MessageNext Message »
From:<Amit_Wadhwa Date:November 5 2004 3:56pm
Subject:RE: Changing Date Type
View as plain text  
Yes, but I want to be able to insert into the column dates in the format
d-mmm-yy

-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@stripped] 
Sent: Friday, November 05, 2004 8:38 PM
To: Wadhwa, Amit; mysql@stripped
Subject: Re: Changing Date Type



> I know that defining a Data datatype in a table renders the date in 
> the form that the database is set to, Ie. yyyy-mm-dd by default.
>
> I want this to remain, but for one particular table, I want to set it 
> to d-mmm-yy Eg. 5-nov-04 or 15-nov-04 instead of 2004-11-05 like the 
> rest of my tables.
> I do not want to change my other tables or their settings, is this 
> possible?

Isn't that just a _display_ format?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
SQL Server.
Upscene Productions
http://www.upscene.com


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