From: Martijn Tonies
Date: November 5 2004 3:07pm
Subject: Re: Changing Date Type
List-Archive: http://lists.mysql.com/mysql/175327
Message-Id: <041a01c4c349$32e872e0$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit



> 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