On Friday 05 November 2004 15:56, [EMAIL PROTECTED] 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]