Because im reading data from another source which is always going to be in this format, and then inserting into the database. Thought if there was a way I could escape having to change the format before I insert into mysql... Sorry abt the high importance, it was turned on by default in my editor.
-----Original Message----- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Friday, November 05, 2004 9:44 PM To: Wadhwa, Amit; [EMAIL PROTECTED] Subject: Re: Changing Date Type > Yes, but I want to be able to insert into the column dates in the > format d-mmm-yy That's a different story. Question though: why? Read some docs: http://dev.mysql.com/doc/mysql/en/Date_and_time_types.html btw, why is your e-mail "important" or "high priority" to me or the list? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com > > 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]
