> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]